Query not connecting

[Guest]

I have a query that is using a combo box on a form for criteria.
This has been working for a year.
Now I am getting parameter messages when ever I try to run the query for the
value in the combo box, which is a date. This is a criteria statement.
My Query Parameter dialog box doesn't have anything entered, and even when I
delete and then readd the criteria using the expression builder, I stll get
nothing.
I can enter the value.
Thanks

 

[Guest]

I had a similar problem recently. You can try the following: Change the
format of your combo box to General Date on your Form Properties sheet. If
it is a bound combo box, change the Table Field Format to General Date. Use
the Eval Function in your query criteria grid like this:

Eval("[Forms]![frmmyform]![cbomyDate]")
For more about the Eval Function see http://support.microsoft.com/kb/198462.

If that fails you can add your criteria to the Parameter Grid of your query.
If that fails send out an SOS to Allen Browne!

Hope it helps,
Hunter57
http://churchmanagementsoftware.googlepages.com/home