MS Access 2010 Pass value to a form

I am developing an application in MS Access 2010.  I have two tables Parts and NSN.  NSN is a child table of Parts.  Below are the table definitions.

Parts.PartsID, Parts.PartNo
NSN.NSNID, NSN.PartsID, NSN.Description.

I need to add a part and then add an NSN record.  I need to get the Parts.PartsID form the Parts form when I open the NSN form.

Make sense?
LVL 1
CipherISAsked:
Who is Participating?
 
Kelvin SparksConnect With a Mentor Commented:
Would you not use a form/subform setup here? This does exactly what you want without you having to intervene.

Kelvin
0
 
CipherISAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.