Referencing a value in a parent form

DaveMere

Registered User.
Local time
Today, 16:19
Joined
Sep 18, 2002
Messages
63
Hi all,

I'm trying to adapt a text box in a subform to reference a value on it's parent form. The subform is present on the 2nd tab of a tab control. The value in the parent form is called "JobNo". I've tried inputting the term "=[Parent].[JobNo]" into the subform textbox data source, and this works to a point. The problem is that when I return to the main tab and move to a different record, the value in the subform does not reflect the changed record - it still displays whatever value was first refernced when then form was opened. I am using Access 2002.

Hope this makes sense!

DaveMere
 

Users who are viewing this thread

Back
Top Bottom