Form pop ups 'Enter Parameter Value'

[var]

HI

when i entered the field information in form it pop ups window titled
'Enter Parameter Value'

asking to enter the values which i have already entered in the form

why it asking again to enter the fields where i have already entered
in the form...??

can anybody help me to solve this

var

 

[Jeff L]

When you get that message, you are trying to run a query that has an
unknown field reference in it. Make sure that the query you are
running does not have any misspellings or the like. Also, if the query
is referring to a field on a form, make sure your syntax is correct.
It should be Forms!YourFormName!YourFormFieldName. Make sure that the
field you are referring to in the query is the same name as field on
your form.

Hope that helps!

 

[var]

Hi Jeff,

as you mentioned, when i tried to declare the Field in my query as
Forms!YourFormName!YourFormFieldName........

and run the form it states me....Rn-time error '3070' and says the
microsoft jet database doesn't recognize the format
Forms!YourFormName!YourFormFieldName as valid field name or expression

i am not sure whats that mean......any help is greatly appreciable

var

 

[Jeff L]

You need to substitute YourFormName and YourFormFieldName with the name
of your form and the name of the field on your form. Also, you put it
in the Criteria of one of your query field, not as a new field in the
query.

 

[var]

hi

disregard my previous message abt run time error, i am able to declare
the format Forms!YourFormName!YourFormFieldNamesuggested,

now id doesn't pop ups to 'Enter Parameter Value' , instead it not
showing the query results its only displaying the headings but there
are no results

what it this.........how do i see my results

Var

 

[Jeff L]

When you only see headings, that means there are no results that match
your criteria.

 

[var]

hi

i am able to see the results efore i declared the field as
'Forms!YourFormName!YourFormFieldName' but after declaration for the
same query there are no results displayed

var

 

[Jeff L]

Ok. You are not quite comprehending this. Call the field in your form
something that is meaningful to you.

For illustrative purposes, I'm going to call the field MyField and the
Form Name is going to be MyForm. Now, in your query, you wish to refer
to the field on the form in the Criteria of a query field. To do that,
you need to use the syntax
Forms!YourFormName!YourFormFieldName.

So in the illustration I used, I would substitute the names I used for
my Form and Field,
Forms!MyForm!MyField. Now in your case, you need to substitute MyForm
with the exact name of your form, and MyField with the exact name of
the field on your form.

Does that make more sense now?