Access 2007 – Controlling Master ID when launching detail form from master form
Hello, I have a master table, and a detail table. (One master record to many detail records, and an ID number that links them.) I have a form that shows the master record data, with a button that launches a form that shows the detail records for that master record. (Where condition ="[Master ID]=" & [ID]). That much works. My problem is, when I want to add a new detail record on that same open form, how do I get it to only allow the new record to have the same master ID? Currently it allows a new record to contain any master id. Thanks very much.
Software/Hardware used:
Microsoft Access 2007
Software/Hardware used:
Microsoft Access 2007
ASKED:
November 26, 2011 5:44 AM
UPDATED:
March 6, 2012 6:59 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Michael Tidmarsh 
11,410 pts. ,
Jersey204 35 pts.
11,410 pts. ,
Jersey204 35 pts. To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
