Synchronize three combo boxes

Question

I am trying to synchronize three combo boxes on an Access form.  I can get combobox1 to synch with combobox2 OR I can get combobox2 to sych with combox3 , but I can't get all three to work together. I downloaded the sample database for synchronizing combo boxes and tried to apply the principles both using queries and macros and the vba version, but the sample only shows two combo boxes and I need three to be synched.  Is it possible to do this?  I have spent about 4 1/2 hours on this without any luck. Any help would be appreciated.

Answer 1

I rapidly put together a very simply example, see the links provided below.

http://www.cardaconsultants.com/files/db5.zip

Note, you would need to implement proper error handling in the VBA code and extra feature such as when the user changes a coutry is should blank region and cities...  But the basic principle is functional.

I hope this helps,

---

Daniel Pineault, 2010-2011 Microsoft MVP

http://www.cardaconsultants.com

MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Yes, it should be possible.

I assume that after user makes a choice in combo1, you want both combo2 and combo3 to show only the records that match the choice made in combo1.

In the after update event of combo1, write code or a macro that sets up the row source for combo2 and write code or a macro that sets the row source for combo3.

The row source for combo3 will need to cope with the occasions when combo1 has a value but combo2 is blank, and when combo1 is bland but combo2 has a value.

---

Jeanette Cunningham MVP(Access) Pakenham, Victoria Australia