unexpected parameters in forms

G

Guest

I have a form that displays requests for parameter values when I try to
display it. However, I don't want, need or desire any parameters. The values
requested appear to be for fields that were in an earlier version of the
database, and I don't see any trace of those fields in the current database
or form. I can't find any references in the form to the requested parameters.
What should I look for in the form to eliminate the erroneous parameter
questiions?
 
D

Duncan Bachen

Twas said:
I have a form that displays requests for parameter values when I try to
display it. However, I don't want, need or desire any parameters. The values
requested appear to be for fields that were in an earlier version of the
database, and I don't see any trace of those fields in the current database
or form. I can't find any references in the form to the requested parameters.
What should I look for in the form to eliminate the erroneous parameter
questiions?

The prompt could be coming from the underlying query that the form is
based on.

Bring up the properties of the form and check out the recordsource.

Try running that query directly, and adjusting (removing) the fields
that have been removed from the database or renamed, etc.
 
J

Joan Wild

Check the form's recordsource - it may be a query that still looking for
those fields.
 
G

Guest

thanks; the references were in the SQL for the recordsource on the subform. I
still don't know why, but removing the references (...AS expr2...) from the
SQL removed the parameter requests. However, the form/subform now shows no
records, so it looks like modifying the SQL created another error.
 

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

Top