enter parameter value

[Serogen]

When I try to open one of my forms I am asked to "enter parameter value". If
I created this prompt, it was by accident. Right now it is asking for a
value that is of little concern to me. I would like to change it to ask for
the phone number. Because I don't know how I got this prompt in the first
place, I don't know how to change it.

 

[MikeJohnB]

You have deleted a field from your Table, and the query that the form is
based on is looking for that value. open the query in design view and delete
the Expr: Column which has no reference to a table.

To get a query to prompt for a date, Enter in the Criteria Row of the date
column,

Like [Please Enter The Date] the query will ask the question in square
brackets each time it is opened.

I hope this answers your question????

Regards

Mike B

 

[MikeJohnB]

Sorry for Date Read Phone Number

Like [Enter the Phone Number] in the criteria row of the Phone Number Column
in the query will prompt for the phone number.

Don't know where I got date from, sorry.

--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

You have deleted a field from your Table, and the query that the form is
based on is looking for that value. open the query in design view and delete
the Expr: Column which has no reference to a table.

To get a query to prompt for a date, Enter in the Criteria Row of the date
column,

Like [Please Enter The Date] the query will ask the question in square
brackets each time it is opened.

I hope this answers your question????

Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

When I try to open one of my forms I am asked to "enter parameter value". If
I created this prompt, it was by accident. Right now it is asking for a
value that is of little concern to me. I would like to change it to ask for
the phone number. Because I don't know how I got this prompt in the first
place, I don't know how to change it.

 

[BruceM]

The prompt should describe the parameter value it is seeking. Look for that
value in an expression in the Record Source query, or in a Control Source or
a Control Source expression on the form, or in the form's code module if
there is one.

 

[Serogen]

First I would like to thank you both for your help. It is such a comforting
feeling to know there is someone out there to offer help!
While I wasn't sure how I created the prompt, your answer helped me fix it
and also understand how to create one (intentionally). Thanks so much!
Sorry it took me much longer to reply than it did for you to answer my
question. I came down with a bug (human; not comp) and have been out of the
office since I first posted.
Thanks so much for your help! It really is greatly appreciated. I am
excited to search through old posts in hopes of finding more answers to my
questions!

You have deleted a field from your Table, and the query that the form is
based on is looking for that value. open the query in design view and delete
the Expr: Column which has no reference to a table.

To get a query to prompt for a date, Enter in the Criteria Row of the date
column,

Like [Please Enter The Date] the query will ask the question in square
brackets each time it is opened.

I hope this answers your question????

Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

When I try to open one of my forms I am asked to "enter parameter value". If
I created this prompt, it was by accident. Right now it is asking for a
value that is of little concern to me. I would like to change it to ask for
the phone number. Because I don't know how I got this prompt in the first
place, I don't know how to change it.