Bringing Up Specific Data in Combo Box (Macro, Maybe?)

[Sandi at the Region]

The forms on my database have fields for (amongst other things) what the problem is, the section to which it’s assigned, and the person within that section. All of the "standard" issue is completed by combo boxes.



Obviously, the department is divided into sections and each section contain multiple employees. When a task is assigned to a section, I want to click on that section in the "Section" combo box, and have another combo box bring up ONLY the people in that section.

So, to illustrate in simple terms:
If I were organizing my wardrobe, I’d have a combo box with:
Shoes
Skirts
Tops

If I click on Shoes, I’d want a combo box to bring up:
Heels
Platforms
Slingbacks

If I click on Tops, I’d want a combo box to bring up:
Blouses
Sweaters
T-Shirts

Simple, eh? Should be. I’ve tried a macro, but although I can use it to open a table, I can't figure out how to open a combo box on a form. Is there a way to do this? Many thanks!

[pbaldy]

Sounds like:

Baldy-Cascading Combos

if it's a form in single view.

[Sandi at the Region]

Many thanks. I still don't understand. I've even tried copying the text from your code into my database, changing it as appropriate, but to no avail. I don't know. I'm giving up on this! But thanks anyway.

[June7]

Here's another tutorial on cascading comboboxes http://datapigtechnologies.com/flash...combobox2.html

[pbaldy]

Many thanks. I still don't understand. I've even tried copying the text from your code into my database, changing it as appropriate, but to no avail. I don't know. I'm giving up on this! But thanks anyway.

If you want to post your db here we can try to fix it.

[Sandi at the Region]

My goodness! It worked! I actually did it! After 3 solid days of sweating over this thing, I actually did it. Thank you so much and consider yourself hugged.

[pbaldy]

Glad you got it sorted, and welcome to the site by the way!

[Sandi at the Region]

Well, I thought everything was going well, until I went back to change info on one of the first records in the database. It changed the information on ALL the subsequent records--and there are 3,000 of them I now have to change! (fortunately I kept a copy of the info, but as far as I know, I still have to go through and change every single record.) This is obviously going to be an ongoing problem. How do I make it so that changes made by using the combo boxes ONLY affect that one record, and not all the rest? (I've done the Requery line) Many thanks.

[June7]

You have the combobox bound to wrong field. The lookup table should not be included in the form RecordSource. Post the form's RecordSource sql statement.