Cascading Combo Boxes

[bellemmar]

I'm really having trouble with these. I have them working in Excel; is it not possible to just import the formatting from Excel to have this work in Access tables/forms?

 

[Alansidman]

Here is a tutorial on how cascading combo boxes work in Access

http://www.fontstuff.com/access/acctut10.htm

 

[bellemmar]

Thank you. I have them working but there's just one thing I can't figure out. When I change the primary box (let's call it State) I want the subsequent box (let's call it City) to go blank. Can this be done?

 

[Alansidman]

Thank you. I have them working but there's just one thing I can't figure out. When I change the primary box (let's call it State) I want the subsequent box (let's call it City) to go blank. Can this be done?

In the afterupdate event for the State combo box put:

me.city.value=""
Me.requery

Alan

 

[bellemmar]

I'm trying to add a 3rd combo box but I can't seem to make it work. I have:
Box 1: Country
Box 2: Province
Box 3: City

Box 1 & 2 work with a code on box 1 after update requery box 2. But if i add that same code to box 2 to requery box 3, it doesn't work.

 

[Alansidman]

See if this helps

http://www.fontstuff.com/access/acctut10.htm

 

[bellemmar]

Still can only get 2 working, not all 3.

 

[Alansidman]

Pat;
I've always used the procedure I referred and not seen yours previously. Do you have a live example that you could post. I'm trying to get my head around your example and maybe its just the time of day or my senior mind not working, but I would like to try this out. Seems at first glance simpler. I will try out when I get home.

This is what I love about forums. Someone always has a better idea to learn from.

Thanks,
Alan

 

[bellemmar]

Okay now here's something bizarre. I have them working on the form. BUT when I try to make the form a subform in another form, they stop working and prompt me to enter a parameter value. I've checked & triple checked that the parameter value in the category query is referencing the right field in the right table. Frustrated!

 

[Alansidman]

perhaps it is time to post a copy of your database so that someone can look at it and see what is happening. Make sure to sanitize it for confidential material and run a compact and repair. Also suggest you save it as an .mdb file as many users still have not upgraded. Try to keep the volume of data limited so that it is not to big.

 

[bellemmar]

Thanks, I figured it out! My category query only referenced the main form & not the subform. It works now. Appreciate the help!

 

[Alansidman]

Thanks again Pat. Very nice presentation. You've convinced me to change.

Alan