Link Subforms based on Parent and Child ID, and open Subform in add new record on open in Access

gracie1972 used Ask the Experts™
How can I link a subform based on a record ID, but have the subform open to only add new records?

I have a main form in access with multiple tabs.  I would like the subform to open in the add record mode but only display the ID from the main form.   Is this possible?

If I have a member ID of 123 on the main form.  I have multiple pages that have worksheets, sub reports or forms.  One page I want linked to a subform based on the member ID, but only open in add new record more with the member ID visible.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Set the DataEntry property of that subform to True. This tells Access to ONLY allow new records to be added.


Thank You!  I knew it would be that simple :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial