gracie1972

<div>
Thank You! &nbsp;I knew it would be that simple :)
</div>


<div>
<div class="content wysiwyg-content">
How can I link a subform based on a record ID, but have the subform open to only add new records?<br />
<br />
I have a main form in access with multiple tabs. &nbsp;I would like the subform to open in the add record mode but only display the ID from the main form. &nbsp; Is this possible?<br />
<br />
If I have a member ID of 123 on the main form. &nbsp;I have multiple pages that have worksheets, sub reports or forms. &nbsp;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.
</div>
</div>


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.

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

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.