Forms wants parameter

[bg1]

I don't have any parameters setup yet when I open a form it asks for
parameter. How can I get rid of this?

 

[Jerry Whittle]

You probably have a text box looking for a field that isn't part of the
record source. maybe someone deleted a field from a table or query. What is
the parameter looking for?

 

[Jeff Boyce]

What is the form based on? A table? A query?

If a query, does that query work correctly if run independently?

Is the form filtered?

Are all the controls in the form bound to existing fields?

What do YOU mean by "don't have any parameters setup" ...?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[John W. Vinson]

I don't have any parameters setup yet when I open a form it asks for
parameter. How can I get rid of this?

Access will prompt for a parameter if it sees something that it doesn't
recognize. For example, if you have a textbox with a Control Source of
[FullName] and there is no such field in the form's recordsource query, it
will ask for it.

Check the spelling (blanks are important, [FullName] and [Full Name] are
totally different fieldnames) and see if the parameter for which you are being
prompted is in fact in the form's Recordsource query.