Main form and Subform

[yakdogs]

I have a main form that has a field called received date, and I need to copy the information to a subform received date as soon as a field has gotten focus.

I can not use parent and child links as the user needs to connect the information in the main form to the records that display in the subform.

I have been trying to use the GotFocus event of the field to copy the data but I keep getting errors.

Can someone give me a sample of how the code should be written?

Thanks

 

[docmeizie]

Put this in the control's main received date After Update event:

forms![SubformName].[ReceivedDate] = Me![ReceivedDate]


If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv