Populate a continuous subform

[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

 

[Guest]

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.