[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

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?
0
CipherIS
Asked:
CipherIS
1 Solution
 
Kelvin SparksCommented:
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now