Populate Field on subform with code from mainform

aldeb

Registered User.
Local time
Today, 09:36
Joined
Dec 23, 2004
Messages
318
Below is the code I have to populate an unbound field on my form.
It worked great until I put the field into the subform. This code is in
an AfterUpdate Event on the main form and I need it to populate a
field on a subform. I do not know how to add the Subform to the code!
I know this is probably something simple but need help.

The Subform name is:
MainEntryQrySelectSub1

Code:
Me.Method10 = DLookup("[Method]", "ReplenishMethodTbl", "[PullSeqCode] = '" & DLookup("[Pull_Seque]", "MainEntryQrySelectSub1") & "'")
 
Forms!MainEntryQrySelectSub1.Method10 = DLookup("[Method]", "ReplenishMethodTbl", "[PullSeqCode] = '" & DLookup("[Pull_Seque]", "MainEntryQrySelectSub1") & "'")
 
Thanks YevS for the help!
 

Users who are viewing this thread

Back
Top Bottom