MICHELE
07-25-2000, 07:53 AM
I have been trying and trying to synchronize 2 combo boxes that are for 2 fields from the same table. I don't know if that's even possible. Eventually I would like to do more than 2 combo boxes and have any one of them synchronize with another one (whichever 2 the user wants). Right now I would just like to get started with 2. I have checked the help wizard and even read some Microsoft articles, including Q97624 on synchronizing combo boxes. I need some tips that will help me get started. Thanks in advance.
Pat Hartman
07-25-2000, 05:25 PM
To synchronize combo boxes, they must be related in some way. For example combo1 shows states, combo2 shows counties, combo3 shows cities. When you choose a state in combo1, that provides the information for combo2 to limit itself to counties in the selected state. When you choose a county, that provides the information for combo3 to limit itself to cities within the county within the state.
MICHELE
07-26-2000, 08:36 AM
Thank you! These fields are related, but I'm not sure if it's what you mean. All of these fields are in one table. I have several fields on one table including: State,Drafter, and Job Type which are all related to the Job number(primary key). So if I had 3 combo boxes(State, Drafter, and Job Type), for example, could I look up all the jobs in the state of TX, then all of the Drafters for the jobs in TX(from the 1st Combo Box) eventhough the State and Drafter are included on the same table? If not, do you have any suggestions about how I could do this?
Thanks again!