Re: Query criterion by form control unsteady

First thing to do would be to turn off Name AutoCorrect.
Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

Then compact the database:
Tools | Database Utilities | Compact/Repair

In Access 2007, it would be:
Office Button | Access Options | Current Database | Name AutoCorrect
followed by:
Office Button | Manage | Compact/Repair

If that does not solve the problem, double-check tha the form is open (not closed, nor in design view.) You can also check this by opening the Immediate Window (Ctrl+G), and entering an expression like this:
? [Forms]![0019_WorkPlanConsult]![Combo6]

It is still fails, switch the query to SQL View (View menu in query design.)
Copy the whole SQL statement out to clipboard.
Close, and delete the query.
Compact again.
Now create a new query, switch to SQL View, paste the statement in, and save it.

If it still fails after that, paste the SQL statement here, and also tell us these properties of the combo:
Control Source
Row Source
Bound Column
Column Count
Column Widths
Format

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Meitatsu" <Meitatsu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A7FCFBE1-1C60-473D-A437-7A774D6BFE02@xxxxxxxxxxxxxxxx
A combo box was assigned as a criterion in a query like
[Forms]![0019_WorkPlanConsult]![Combo6]. When I updated the combo box and
tried to open the query, Access shows an error message "Microsoft JET
database engine does not recognize '[Forms]![0019_WorkPlanConsult]![Combo6]'
as an effective field or operator" in my language.
But it did work few days ago. Will anyone give any comment about that?
Any comments will be much appreciated.
Thanks in advance!
--
Meitatsu
Taiwan

.