Form asking for Parameter V - Continuous Forms in Microsoft Access


	Back to Continuous Forms Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Form asking for Parameter V

Larry Fisackerly

2 years ago

I have MasterT. I created query StevenQ using 4 fields from MasterT. Query works. I created Form StevenF (using Form Design) with property source "StevenQ". When I open StevenF, I get dialog box asking for parameter for "Enter Parameter V... for "MasterT.ID" If I click OK without entering a value, the form works. Why am I being ask for "MasterT.ID?" I don't have a field with that name. I don't know what "MasterT.ID" means. How do I fix this?

	Sami Shamma @Reply 2 years ago
Spelling Spelling Spelling watch this video Enter Parameter Value also send a screenshot of your Query in design view

	Larry Fisackerly OP @Reply 2 years ago

	Larry Fisackerly OP @Reply 2 years ago

	Larry Fisackerly OP @Reply 2 years ago
If I click "OK" without entering a Parameter, the form works. I have no idea what PNC_Master_01T.ID is. I have uploaded 2 screenshots. PS, I understand Parameters queries. Thanks for the Parameter video.

	Sami Shamma @Reply 2 years ago
Check your form. It is on it. That is why Access is asking you for its value.

	Sami Shamma @Reply 2 years ago
And it is not on your Query.

	Richard Rost @Reply 2 years ago
We can't see the whole query. Either slide the pic to the right so we can see the rest of the columns, or show us the SQL view. Do you have any query parameters specified using the "Query Parameters" dialog? I just realized I haven't done a video on this yet. One is coming shortly.

	Kevin Robertson @Reply 2 years ago
Try adding the ID to the Query.

	Larry Fisackerly OP @Reply 2 years ago

	Larry Fisackerly OP @Reply 2 years ago

	Larry Fisackerly OP @Reply 2 years ago

	Richard Rost @Reply 2 years ago
That's definitely a weird one. Let's see the SQL for it.

	Larry Fisackerly OP @Reply 2 years ago

	Richard Rost @Reply 2 years ago
Try with Kevin said and make sure you add the ID to the query output Fields itself. We'll see if that fixes it. Also, I know this sounds silly but double-check and make sure that's actually a table. I've had people before that have accidentally named queries with 'T' on the end of it, and that causes all kinds of problems if you think it's a table and it's really a query.

	Larry Fisackerly OP @Reply 2 years ago

	Larry Fisackerly OP @Reply 2 years ago

	Larry Fisackerly OP @Reply 2 years ago
I added the ID field to the query and that solved the problem. The form works as expected. Why do I need the ID in the query when it is not used in the form? A million thanks to everyone for assisting in this head scratcher. Please check the tip jar.

	Richard Rost @Reply 2 years ago
Does the query give you that parameter prompt if you JUST run the query without the form? If not, then the form is asking for it somewhere... a filter or an orderby perhaps?

	Larry Fisackerly OP @Reply 2 years ago
This is getting weird. I created a new form from scratch using the query containing the ID field. Form did not request parameter value. I removed the ID field from the query, and ran the form. It requested the parameter value.

	Richard Rost @Reply 2 years ago
Well if you created a new form based on that query while it had the ID in it, the field would have been added to the form's RecordSource property - most likely.

	Larry Fisackerly OP @Reply 2 years ago
You have gone above and beyond in helping me. I am going to file this under "Go Figure". Let's close this issue.

	Sami Shamma @Reply 2 years ago
Thank you Larry

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Continuous Forms.

Next Unseen

New Feature: Comment Live View