parameter from a form

J

J

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
 
O

Ofer Cohen

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
 
Top