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.