Subform linked to form - ID number to come into subform?

C

CarolD

I am an Access novice with no VB experience.
I have created a form (Software Register) with a subform (Licence No). The
related tables have a relationship defined with Software_ID_No.
The subform has the Child and Master fields with Software_ID_NO and moves
with the form if I manually enter the Software_ID_No.
How do I get the subform to automatically show the main form's
Software_ID_No, and also record it in the subform's table.
If you can answer this, please do it in steps :)
 
P

PieterLinden via AccessMonster.com

CarolD said:
I am an Access novice with no VB experience.
I have created a form (Software Register) with a subform (Licence No). The
related tables have a relationship defined with Software_ID_No.
The subform has the Child and Master fields with Software_ID_NO and moves
with the form if I manually enter the Software_ID_No.
How do I get the subform to automatically show the main form's
Software_ID_No, and also record it in the subform's table.
If you can answer this, please do it in steps :)

If you create a relationship between the two tables in the Relationships
window, when you drop your subform (based on License) into your main form
(based on Software), the LinkChild and LinkMaster properties of the subform
should be filled in for you. If they are not, you should be able to select
the fields that link the two tables. Then the subform should work properly.
 

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

Top