<div>
I know how to create a single form, I Require multiple forms to build a product as it goes. &nbsp;Like if it's left or right, the rest of the options on the remaining forms would need to be taylored to that.
</div>


I know how to create a single form, I Require multiple forms to build a product as it goes.  Like if it's left or right, the rest of the options on the remaining forms would need to be taylored to that.

<div>
Buid your forms and bind them to the table. &nbsp;To filter them to the correct record on opening:<br />
<br />
DoCmd.openform &quot;frmYourFormName&quot;,,,&quot;ID = &quot;&nbsp;&amp; me.ID<br />
<br />
This is assuming that you are launching the forms from some &quot;main form&quot; bound to the table. &nbsp;You need something like this to let the other forms know what record you are working with.
</div>


Buid your forms and bind them to the table.  To filter them to the correct record on opening:

DoCmd.openform "frmYourFormName",,,"ID = " & me.ID

This is assuming that you are launching the forms from some "main form" bound to the table.  You need something like this to let the other forms know what record you are working with.

<div>
Actually, I think your first suggestion will work just fine inside of Tabs =-) &nbsp;Thanks.
</div>


Actually, I think your first suggestion will work just fine inside of Tabs =-)  Thanks.

<div>
Glad to help, but why the &quot;B&quot; grade?
</div>


<div>
:) &nbsp;Not everyone can score an A for everything. &nbsp;It wasn't EXACTLY what I was looking for but turned out to work okay. &nbsp;;-)
</div>


:)  Not everyone can score an A for everything.  It wasn't EXACTLY what I was looking for but turned out to work okay.  ;-)

<div>
<div class="content wysiwyg-content">
I want to create multiple forms that will gather information and store it in one record. i.e. Step 1 (what size?) Step 2 (what color?) Step 3 (What is it?)<br />
<br />
Each step is it's own form that add information to the same record.
</div>
</div>


I want to create multiple forms that will gather information and store it in one record. i.e. Step 1 (what size?) Step 2 (what color?) Step 3 (What is it?)

Each step is it's own form that add information to the same record.

Build one record with multiple forms

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.