View Full Version : MSAccess multiselect property in form


Nolan Adams
10-13-2004, 11:43 AM
I have a very simple form with one table that has 2 fields...autonumber which is Primary Key field (No Dups) and a text field. I want the user to be able to select one, some or all of the records and then have the 'After double_click expression to find these records. The RecordSelected, Selected and other values do not give me any information. If you can give me some sample code I would really appreciate it. I can find records in a table when the 'multiselect' property is "NONE". Obviously I am very NEW to Access. Thanks.

M8KWR
10-14-2004, 09:03 AM
so let me get this right, you want a list box on a form, that the user select one or multiple records, click on a button, then a form opens up with just what they have select in the previous list box...

Is that what you need...

WayneRyan
10-14-2004, 10:30 AM
Nolan,

You're essentially going to have to traverse your ListBox and build a query.
Actually, you'll only be building the WHERE clause of the query.

Use the Search Facility here and look for "QueryDefs" and do a second
search on "multiselect" and/or "multi-select". There will be examples.

I don't know if the Sample Databases forum here has any samples, but
that will get you started.

Wayne