Query from combo box problem

[szuccaro]

Hey aLL,
TRying to display a query with the following query:
====================================================

SELECT tickets.*
FROM tickets
WHERE tickets.datein = [Forms]![Form1]![Combo4].value;

=======================================================
I hit the button that runs the query and it either does nothing or just says "you have canceled the previous operation" ????

What am i doing wrong ?

-Steve

 

[lupins46]

There is nothing visibly wrong with this query.
What is happening on the form before you click the button?
Did you build the button using the Toolbox wizard?
If not, can you show the code for the button click event.

 

[szuccaro]

code for the button is pretty simple.
All i do is this:

Me.Combo4.SetFocus

Dim stDocName As String
stDocName = "get_tickets_by_date"

DoCmd.OpenQuery strSQL, acNormal, acEdit

 

[dhookom]

I don't see any reference to "strSQL" except in the OpenQuery line. Where is this from?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.