parameter from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I enter the criteria to get the information from the form
ex:
[Form]![department frm]![Department]
the form does not appear when I run the query.
Instead the parameter prompt appears stating
Form!department frm!Department
 
A couple of things
1. What do you ,mean the form doesn't apear?
The form need to be open so the query will recognize the field, other wise
you will be prompt to enter the parameter

2. The : [Form]![department frm]![Department]
Need to be: [Forms]![department frm]![Department]

Forms Instead of Form
 

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

Using form to fill in query criteria not working 2
Complex Criteria Parameter Query 2
update query help 2
Excel Wildcard in Excel array formula 0
update query problem, need help. 1
multiple selection criteria with wildcard 4
Criteria Script for a Query 1
update query: still having problems 19

Back
Top