Synchronizing Combo Boxes

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I need to synchornize two combo boxes

1st combo box contains the "QUESTION NAME"

2nc combo box contains the "CATEGORY"

What is the event procedure or the macro to make this happen?

Thanks.
 
For the first combo the onclick event

set up a query that returns the possible values of Category for the Question
clicked on

me.ComboOne returns this value
so the query is something like

"SELECT CategoryId, CategpoyTxt FROM categorie WHERE question = " &
me.comboOne
then set this as the rowsource for the second Combo

me.comboTwo.Rowsource = sql

then requery the combo

me.ComboTwo.requery

It will thendisplay only the categories you want

[You may can hide the Id's and just show the text by making the id column
zero width

something like comboOne.columnwidths = 0cm; 2.5cm]
 
I need to synchornize two combo boxes

1st combo box contains the "QUESTION NAME"

2nc combo box contains the "CATEGORY"

What is the event procedure or the macro to make this happen?

Thanks.
Click to expand...

What do you mean by "synchronization"? What is the relationship between
quetion names and categories? It might help to post the SQL view of the
Rowsource queries of both combos, or (if they're based on a table) the
relevant table fields.
 
Back
Top