By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

forms query

P: n/a
i've got a problem with a form in my database. I've renamed the table that
the form is associated with and for some reason it now puts up a dialogue
box asking to enter a parameter value for one of the fields before it opens.

This is despite the fact that no queries have been set up and even if i
leave the field blank and click ok it opens the form up anyway at the first
record! How can i ger rid of the dialogue box?

Thanks in advance for any solutions

Stephen
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Stephen Chaplin" <sc**@york.ac.uk> wrote in message
news:c7**********@pump1.york.ac.uk...
i've got a problem with a form in my database. I've renamed the table that the form is associated with and for some reason it now puts up a dialogue
box asking to enter a parameter value for one of the fields before it opens.
This is despite the fact that no queries have been set up and even if i
leave the field blank and click ok it opens the form up anyway at the first record! How can i ger rid of the dialogue box?

Thanks in advance for any solutions


A parameter prompt happens anytime Access sees a field reference that it
can't find. This is what is intended in a parameter query, but it can also
happen when mistakes are made. Usually you have a field reference spelled
wrong or something similar.

Does the field that you are being prompted for exist in the forms
RecordSet?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

P: n/a
yes the field is there.

i cant understand why it can no longer find it. All i've done is change the
table name from 'STHA data collection' to data collection. Surely the form
should know to look in this table now as it always has done with other
databases that i've set up.

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:2f************@uni-berlin.de...
"Stephen Chaplin" <sc**@york.ac.uk> wrote in message
news:c7**********@pump1.york.ac.uk...
i've got a problem with a form in my database. I've renamed the table that
the form is associated with and for some reason it now puts up a dialogue box asking to enter a parameter value for one of the fields before it

opens.

This is despite the fact that no queries have been set up and even if i
leave the field blank and click ok it opens the form up anyway at the

first
record! How can i ger rid of the dialogue box?

Thanks in advance for any solutions


A parameter prompt happens anytime Access sees a field reference that it
can't find. This is what is intended in a parameter query, but it can

also happen when mistakes are made. Usually you have a field reference spelled
wrong or something similar.

Does the field that you are being prompted for exist in the forms
RecordSet?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 12 '05 #3

P: n/a
CDB
The form only knows what you have told it.

Open the form in design view, and look at the recordsource property. Make
sure that it uses the name of your revised table.(You may have set up the
form using an Access Wizard, which behind the scenes copies the SQL
statement of the query as its recordsource, rather than the name of the
stored query.)

Clive
"Stephen Chaplin" <sc**@york.ac.uk> wrote in message
news:c7**********@pump1.york.ac.uk...
yes the field is there.

i cant understand why it can no longer find it. All i've done is change the table name from 'STHA data collection' to data collection. Surely the form
should know to look in this table now as it always has done with other
databases that i've set up.


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.