enter parameter value message when opening form

K

Karen TS

I am creating a form, and now all of a sudden when I try to go into the form
I get a message that asks me to "enter parameter value". This message has
never shown up before and I'm not sure how it was initiated. Can someone tell
me why it is there and how I remove it
 
K

Klatuu

There is a query somewhere in your form that has a parameter in it. It may
not be obvious. It could be the row source for a list box or a combo box,
for example.
 
O

Ofer

You might have removed a field from the table that the form is bound to, but
the field wasn't removed from the form record source
Run the sql of the record source of the form, to see if you ask to enter a
parameter.
 
K

Klatuu

Clever techinque, Ofer!

Ofer said:
You might have removed a field from the table that the form is bound to, but
the field wasn't removed from the form record source
Run the sql of the record source of the form, to see if you ask to enter a
parameter.
Click to expand...
 
K

Karen TS

I am new at this, so please bear with me....How do I run the sql of the
record source?
 
O

Ofer

Open the form in design view, in the tool bar select view, properties, or
press Alt+Enter.
Now, to select the properties of the form, click on the top left corner of
the form.
In the Properties, view all properties, the top property is the record source.
Now press on the button with the three dots.

Now run the SQL.
 
K

Karen TS

when i press the button with the 3 dots, it asks me if I want to create a
query based on the table. I don't want a query. I want it to stop asking me
to "enter parameter value" every time i open the form. Do i need to make a
query before i can get it to stop asking me to do that?
 
O

Ofer

You don't need to create a new query, check the name it of the table in the
record source, if it's a table then you have no problem there, you better
check the source of the combo's just as Klatuu suggested.
If the record source of the form it's a query and not a table, then run and
check the query.
 
K

Karen TS

help please, i'm not understanding what you are asking me to do to find the
parameter error. If i look at the properties of my list or combo boxes how do
i tell if there is an error?
 
K

Karen TS

I think I found the answer in a previous post from Van T Dinh...thank you all
for you help.
 
Top