Cascading Combo Boxes - Cascading Combo Boxes in Microsoft Access


	Back to Cascading Combo Boxes Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Cascading Combo Boxes

Chris Lopez

10 months ago

I watched the video on cascading combo boxes for cities and states.
The question I have is, in the criteria section, you name a form to use that cascading combo box,I have several different forms that would use this same cascading combo box to show cities and states, is there a way to have this query on every form?

	Bill Carver @Reply 10 months ago
field names on all forms the same. copy and paste

	Chris Lopez OP @Reply 10 months ago
What do I copy and paste?

	Bill Carver @Reply 10 months ago
On all the forms you're creating, if you name the fields the same, you can copy and paste your combo boxes from a form where they're working to any other form and they'll work in their new home.

	Chris Lopez OP @Reply 10 months ago
So if I set it up correctly on one form and copy the combo boxes to other forms, it will work without changing any criteria?

	Bill Carver @Reply 10 months ago
it should

	Chris Lopez OP @Reply 10 months ago
I'm not sure what I'm doing wrong. When I follow the video and click run to run the query, I get a box that says Enter parameter value? Any ideas what I could be doing wrong?

	Sami Shamma @Reply 10 months ago
Enter parameter value? = Wrong Spelling watch this video Enter Parameter Value

	Chris Lopez OP @Reply 10 months ago
So I got it to work, but it was an error on my part(Obviously). Now, all the pre-selected cities populate correctly, but is there a way to type in a different city that is not on the list? If so, will it save to the database, or would I have to edit the database to save it?

	Sami Shamma @Reply 10 months ago
No, you don't have to do that. There's a feature in Access: Allow Vale list edit. Richard covers it in beginner 8.

	Kevin Robertson @Reply 10 months ago
List Items Edit Form

	Sami Shamma @Reply 10 months ago
Kevin funny, I could not find this video

	Chris Lopez OP @Reply 10 months ago
Can I run multiple queries for this on the same form? Say one is for the city and state, and the other is for the employee's name and ID number, both on the same form? If so, how?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Cascading Combo Boxes.

Next Unseen

New Feature: Comment Live View