Query Selection - Multiple choices, one field

[e_lady]

I have a database which keeps track of a trucking business. Each truck has a trailer number. I have no problem having a query prompt the user to enter a single trailer number to query on. What can I do when the customer needs to select more than one trailer number to query on?

 

[MStef]

Hello e lady!
Look at "DemoMorePromptA97.mdb"

 

[e_lady]

Thanks, that works. I am still working on it looking cleaner for the user. Maybe some sort of list to pick from. Any ideas?

 

[Mile-O]

Personally, I'd use a form with a multi-select listbox on it and then just build the necessary query.

 

[e_lady]

Thanks - that's what I am working on.