Solved

MS Access 2010 Pass value to a form

Posted on 2014-01-05
2
426 Views
Last Modified: 2014-01-05
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
Comment
Question by:CipherIS
2 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
Comment Utility
Would you not use a form/subform setup here? This does exactly what you want without you having to intervene.

Kelvin
0
 
LVL 1

Author Closing Comment

by:CipherIS
Comment Utility
Thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now