Cascading Comboboxes to populate table

[Xcalibur]

I have used your very informative information on cascading comboboxes. It works well except when the requery activates it erases all information in the childID field on all records except the current one.

In the cboParent AfterUpdate event I have the following code:
Me.cboChild.Requery
This is what erases all other information in the other records. What else can I use to keep the cboChild updated? I tried a DLookup in the forms Current event, however, I have problems with the correct syntax.

Thanks.