Novice
Windows XP 
Access 2007
I'm a newbie. I have a master record (Donor Record) with a subform (Notes). This Donor Record has a key field, which is a number, called ID.
On a Donor Record, in the Notes subform, I want to click create new record and have the resulting new Notes record contain the ID number from current Donor Record, creating a one-to-many relationship, with records (notes) sorted chronologically.
Right now, I am seeing ALL the notes in the Notes table.
What do I need to do?
Who is John Galt?
Windows XP Access 2007
The subform control (the control on the main form, not the subform itself) has master/child link properties. You want to set those to the ID field in each table. If you used the subform wizard, it should have asked about linking fields.
18 year novice
Windows XP Access 2007
Have you tried setting the default ID in the subform to the ID in the master record, e.g. Forms.Donor.ID ?
PBaldy's comment should have taken care of your problem.
Last edited by hertfordkc; 10-13-2011 at 11:37 AM. Reason: Incomplete, maybe incorrect
Novice
Windows XP Access 2007
Well, that was quick and worked perfectly. Thank you!
Who is John Galt?
Windows XP Access 2007
Happy to help!
Data entry subform: how to add a field in the record but not on subform
Posting Permissions
Reply With Quote