linking field from main form to sub form

Stoic

Registered User.
Local time
Today, 08:08
Joined
May 15, 2013
Messages
24
Hi,
I have an entry form with a field(combo box) called cboGetCode. I also have a sub form (continuous form) with number of fields, also an entry form. Now, I have added a code behind the cboGetCode AfterUpdate event to populate the result to relevant fields in the main form.
PHP:
Me.lngSCode = DLookup("[lngSchoolCode]", "[qrReadingFirstSchools]", "[lngSchoolCode]='" & Me.cboGetCode & "'")

This is working very well.
Now, what I would like to do is get code as shown in the cboGetCode field to my sub form lngSCode field.

Any help?
 

Users who are viewing this thread

Back
Top Bottom