<div>
<div class="content wysiwyg-content">
I am developing an application in MS Access 2010. &nbsp;I have two tables Parts and NSN. &nbsp;NSN is a child table of Parts. &nbsp;Below are the table definitions.<br />
<br />
Parts.PartsID, Parts.PartNo<br />
NSN.NSNID, NSN.PartsID, NSN.Description.<br />
<br />
I need to add a part and then add an NSN record. &nbsp;I need to get the Parts.PartsID form the Parts form when I open the NSN form.<br />
<br />
Make sense?
</div>
</div>


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?

MS Access 2010 Pass value to a form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.