Form Query

R

rap43

I am trying to run a query for a form, I am using the following criteria
[form]![frmSchoolsQry]![txtschool] .
The form name and the text box from the form.
When I click the command button the launch the query a parameter dialog pop
up.
The dialog ask for the text that is in the text box. I use forms to query
dates, they work great, why don’t this work?
Any suggestions?
 
R

rap43

Thanks Nothing Like A Missing S, I've look at all day

Thank Again

Douglas J. Steele said:
You're missing an s in Form:

[Forms]![frmSchoolsQry]![txtschool]

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


rap43 said:
I am trying to run a query for a form, I am using the following criteria
[form]![frmSchoolsQry]![txtschool] .
The form name and the text box from the form.
When I click the command button the launch the query a parameter dialog
pop
up.
The dialog ask for the text that is in the text box. I use forms to query
dates, they work great, why don't this work?
Any suggestions?
Click to expand...
Click to expand...
 
Top