Form Query

G

Guest

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?
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Connecting Text Box in Query Criteria 4
Query Parameter using multiple options 0
Why does query execute before OnLoad event of Form 7
Append query and combo box on the form 1
Query Results in a Text Box 3
Dates in a form for filtering Report query 4
Enter Parameter Box pops up even though its not in query 7

Top