enter parameter value


S

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

Advertisements

M

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
 
M

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


MikeJohnB said:
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


Serogen said:
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.
 
B

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

Advertisements

S

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!



MikeJohnB said:
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


Serogen said:
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.
 

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