specific records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AttackIP - 10 Nov 2005 00:36 GMT

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!

Reply to this Message

Allen Browne - 10 Nov 2005 01:37 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>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,
[quoted text clipped - 3 lines]
>
> Thanks!

Reply to this Message