Multiple combo bo issues.

[PuddinPie]

Hello,

I am having an issues where I have a form with a start and end date combo boxes and also an employee combo box. I want the user to be able to select a start and end date and an employee name and display an excel sheet with the stuff that was done for that date range for that person.
I have it so that it creates a make table query. The date range works fine but it displays everybody instead of just the person I've selected.
Is there a criteria that I should be inputing or something I'm over looking. Should I be using bound combo boxes or is unbound ok?

THank you.

 

[Mr. Hero]

Have one of your queries create a table with the information searched.

 

[PuddinPie]

That's what I do have. I have it that when you click on the select button in the query that it creates a table useing a make table query.

 

[PuddinPie]

Ok. I figured it out. I needed to put in [Forms]![frmDataUsage]![cboEmployee] into the critera for the query.

Thank you for your help.

 

[Mr. Hero]

I am glad you were able to fix your issue.

 

[boblarson]

I have it so that it creates a make table query.

Why? You don't need to have a table for this. All you need is your query and it can be exported to Excel. Queries can be used in about 99.9% of the places that tables can be used. So, don't add overhead and database bloat to your database by using a make table query. There are some rare instances where they are useful but if your query runs quickly, you can just use the query.