Selection form for all records in one table (simultaneously)

[Scanner]

I need a form that when launched will read and display all of the records in a table at the same time.

My company authors software and not all of the patches released are for every version.

I have a main Update Release table (and associated form) where the details of a given patch are kept and a second table that lists all versions of the software.

I would like to create a sub-form that would be launched from the Update Release form listing all versions of the software with checkboxes that I could select to keep track of which versions are applicable for that given patch.

 

[Remou]

What is the problem?

 

[CharlieT302]

If I am understanding you correctly, you need to create a relational subform.

You stated you already had a form for the Update Release Table. Create one for the details table as well.

Place the main form (Update RElease) in design view.
Size the detail section so that you have enough room to place the subform.
On the Toolbox toolbar, click the Subform button.
Click directly under the existing fields in the detail section.
Follow the wizard thru the selecting of the new subform and tell it which fields to use to link on (I suggest using the Define my own option). Remember, both tables must have a common field.

Then size and move the subform to your wishes.

That should be it.