Multichoice in form

[Guest]

I have a situation in my Access 2003 application where I would like the users
to be able to pick one or more records from a table for further "treatment".
The users should be able to pick more than one record and then the
application should use those records for creating a report based on
information related to all the selected record. Not just one record. The
report is now created based on one record from that table without any
problem. But now I need to be able to create a similar report based on
possibly several record. What should I do to give the users this multichoice
in a form?

Thanks

Madeleine

 

[Guest]

Dear Madeleine,

Is there any common field joining those 2 records? (e.g. ClientID or perhaps
two different IDs?)

If that is true how do you filter your information for the time being? Using
a combo to find that record? Perhaps the answer will be to place two text
boxes on your form and then to filter those two records according to the
input on those text boxes.

Also you can use the same query with criteria equals to
Forms![YourFormName]![YourFirstTxtBoxName] or
Forms![YourFormName]![YourSecondFirstTxtBoxName].

Hope this helps,

George


Ο χÏήστης "Madeleine N" έγγÏαψε: