Populate a continuous subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello guys.

I have a form and a subform. Since the user wants me to show in the subform
a record in red if a previous record has a different value I've tried to do
it with VBA. So far the problem is that the continuous subform only shows the
last record. Perhaps I'm using the wrong event but I can't make the
continuous subform behave as it normaly does when using the Access
parammeters linkchildfield and linkmasterfield.
Thanks for your help
 
Hello Guys.

To help you to help me, this is the code I've written in the Current event
of the main form:

With ce_rs
.MoveFirst
While Not .EOF
Form_sub_cargas2.IDSGS = !IDSGS
Form_sub_cargas2.piso = !piso
Form_sub_cargas2.bodega = !bodega
Form_sub_cargas2.palet = !palet
Form_sub_cargas2.cajas = !cajas
Form_sub_cargas2.fecha = !fecha
Form_sub_cargas2.Muelle = Muelle
.MoveNext
Wend
End With

What I guessed was that the continuous subform will behave as when linked in
Access, but as I stated, only showed the last record.

Thanks for your help.
 
Back
Top