Master form - subform question

  • Thread starter Thread starter *** Jack ***
  • Start date Start date
J

*** Jack ***

I have a Master form which displays several fields of information which
include the [ProjectNumber] field and the [Creator] field. On the bottom
half of the Master form is a subform. This subform displays all the
drawings which are part of the [ProjectNumber], [Creator] displayed on the
Master form. While I am on the subform, I can add records to the data
displayed on the subform. When I add a record I want to record this
addition in another table.

How do I reference the fields on the Master Form ? I can simply do
Me.<Fieldname> to reference the data on the subform, but I cannot figure out
how to reference fields on the Master Form.

TYIA,
Jack
 
You can also use the "Parent" Property of the Subform.

Check Access Help on the above Property for next time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update a secondary table based on the master table 3
Linking One child field or another in subform to main form 4
Basic sub-form functionality 4
sub forms which do not update automatically 1
Subform Data Entry Setting 0
Link subform field to master form 3
show data from subform in master form 5
Link subform ID control 3

Back
Top