forms query

[Stephen Chaplin]

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

[Rick Brandt]

"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

[Stephen Chaplin]

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

[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.