Linking Check Boxes or List Box to Query

C

cheekyblue

Hello, I am hoping someone can help me out here as I am pulling my hair out.

I have a form that has unbound fields as follows
Text Box - Start Date
Text Box - End Date
Combo Box - Call Type

and a button that runs the query which includes the fields
Call Date - Between [forms]![FrmMarketingStats]![txtCallDateStart] And
[forms]![FrmMarketingStats]![txtCallDateEnd]
Call Type - [forms]![FrmMarketingStats]![cboCallType]
Company (no criteria required)
Successful (this is the part I need help with)

The available options for Succesful are - Yes, No or n/a

I can achieve this by adding a combo box (cboSuccess) listing Yes, No or n/a
and this works perfectly with the criteria
[forms]![FrmMarketingStats]![cboSuccess]

BUT, what I really need is to be able to select multiple items, ie show me
all calls that have Yes or No entered. I have inserted a Listbox and set it
to accept multiple entries, but for some reason my query does not like
this...... what do I do??? please can someone help me out here, I'm going
crazy!

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word OLE to check spelling in text box 1
Combo or list box 0
Combo or list box 0
Creating a Search using a combo box and then creating a report. 4
query to show where no data in a stated column 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Combo box 0
Dynamic Naming of Form Button 3

Top