Query Criteria is too complex

[Adrian Tache]

I'm having an issue with a query search for invoices where the due date of the invoices searched is provided through a combo box in a form

the combo box has the following code:

 DoCmd.OpenQuery "Invoice by Due Date"
    Me.Combo0 = ""

it basically runs the query which has the condition below which equates invoice due date to:

[Forms]![Timesheet by Employee]![Combo0]

to which i get a 3071 expression too complex error. same error if I run the query directly. ran the same setup for employee names and it worked flawlessly. When i ran that query it returned a prompt for [Forms]![form name]![Combo0]

umm, help? :D

[Mariostg]

You should post the SQL statement of the query itself. I don't think there is enough details here for anyone to help.

[NeoPa]

I think it needs more than just that Adrian. You need to ask the question more clearly. I read it and then think to myself What did that just say? I still have very little idea what your problem is.

[Adrian Tache]

not exactly sure how to explain it differently...

the query is a simple show all query but done in design view in order to set the condition for the field to equate to the combo box in the form

it's a complex thing which is why i personally can't explain it differently

[Mariostg]

Adrian,
I those circumstances, I am afraid I cannot help. Maybe somebody else will. Clearly, I don't have enough information.

[Adrian Tache]

don't worry about it, it's not a crucial thing

thanks for your time though :)