specific records

[Guest]

I need a query and a form that will allow users to access specific multiple
records. In this case, membership numbers from a table i.e. 2131, 1132,
4327... I understand the IN (2131, 1132...) criteria function, but how do I
incorporate that into a form that asks for those multiple memNumbers?

Thanks!

 

[Allen Browne]

Create a related table to hold the related memberships. You will have a
many-to-one relation from this table back to your existing table.

Then create a main form, with a subform where the memberships can be
selected, one per row.