If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Synchronizing Combo Boxes
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. -- Denise B. |
#2
|
|||
|
|||
Synchronizing Combo Boxes
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] "Denise" wrote in message ... 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. -- Denise B. |
#3
|
|||
|
|||
Synchronizing Combo Boxes
On Thu, 21 Jan 2010 10:59:01 -0800, Denise
wrote: 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. 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Synchronizing Combo Boxes
See Allen Brownes explanation of cascading combo boxes at www.allenbrowne.com
-- Milton Purdy ACCESS State of Arkansas "Denise" wrote: 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. -- Denise B. |
Thread Tools | |
Display Modes | |
|
|