"The Microsoft Office Access database engine does not recognize...

  • Thread starter Thread starter ant1983
  • Start date Start date
A

ant1983

I have a query and one of the fiels is numLevel. Then i have a form wirh an
unbound combo called txtLevel.

then in that query in criteria under numLevel i have:
[Forms]![frmEmailScheduleToClientMenu]![txtLevel]

So if i select a value from the combo box and click my command button to
open the query it shows me the correct results.

The problem is i want to change the name of the combo box on my form to
numLevel. I do that and save and then go change the criteria to:

[Forms]![frmEmailScheduleToClientMenu]![txtLevel]

But then when i run the query it says:

"The Microsoft Office Access database engine does not recognize
'Forms!frmEmailScheduleToClientMenu!numLevel as a valid field name or
expression."

Why is that? I changed it both places?
 
I have a query and one of the fiels is numLevel. Then i have a form wirh an
unbound combo called txtLevel.

then in that query in criteria under numLevel i have:
[Forms]![frmEmailScheduleToClientMenu]![txtLevel]

So if i select a value from the combo box and click my command button to
open the query it shows me the correct results.

The problem is i want to change the name of the combo box on my form to
numLevel. I do that and save and then go change the criteria to:

[Forms]![frmEmailScheduleToClientMenu]![txtLevel]

But then when i run the query it says:

"The Microsoft Office Access database engine does not recognize
'Forms!frmEmailScheduleToClientMenu!numLevel as a valid field name or
expression."

Why is that? I changed it both places?
Click to expand...

You say the criterion is txtLevel, but that you changed the name to numLevel.
Which is it? What is the Name property of the textbox on the form?
 
Sorry, i meant i change it to numLevel in bothe places and then get the error.

John W. Vinson said:
I have a query and one of the fiels is numLevel. Then i have a form wirh an
unbound combo called txtLevel.

then in that query in criteria under numLevel i have:
[Forms]![frmEmailScheduleToClientMenu]![txtLevel]

So if i select a value from the combo box and click my command button to
open the query it shows me the correct results.

The problem is i want to change the name of the combo box on my form to
numLevel. I do that and save and then go change the criteria to:

[Forms]![frmEmailScheduleToClientMenu]![txtLevel]

But then when i run the query it says:

"The Microsoft Office Access database engine does not recognize
'Forms!frmEmailScheduleToClientMenu!numLevel as a valid field name or
expression."

Why is that? I changed it both places?
Click to expand...

You say the criterion is txtLevel, but that you changed the name to numLevel.
Which is it? What is the Name property of the textbox on the form?
Click to expand...
 
Sorry, i meant i change it to numLevel in bothe places and then get the error.
Click to expand...

Please post your actual query in SQL view, and indicate the Name properties of
your form and the relevant form controls.
 
Back
Top