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
|
|||
|
|||
COMBO BOX - IF/THEN STATEMENTS
I have a combo box in a form with values pre-entered. Depending on which
value the user pulls in the first combo box, I would like a second combo box to pop up with secondary values associated with the primary value entered in the first combo box. Don't know enough VB or any SQL to get this done. This would be the modern-day equivalent of an if-then statement in Basic (yes, that's the last programming code I learned). |
#2
|
|||
|
|||
COMBO BOX - IF/THEN STATEMENTS
I have a form that is similiar to yours. What I did is create a query for the
2 items (Category and Subcategory, where I only wanted specific subcategories associated with the cateogory). The query included only category & subcategory. The criteria for category is: Iif(isNull([Forms]![FormName]![cboCategory]),[Category],[Forms]![FormNames]! [cboCategory]) In my form, I named the category combo box cboCategory, using the query as the row source, column count 1. On the subcategories combo box, the row source is the same query, column count 2, column widths 0";1", bound column 2. Hope this helps. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200611/1 |
#3
|
|||
|
|||
COMBO BOX - IF/THEN STATEMENTS
This link describes two methods of doing it:
http://www.mvps.org/access/forms/frm0028.htm Post back if you need help. Additional Reference: http://www.comeandread.com/access/tip016.htm "childe51" u29423@uwe wrote in message news:69a2a2e2a6be1@uwe... I have a combo box in a form with values pre-entered. Depending on which value the user pulls in the first combo box, I would like a second combo box to pop up with secondary values associated with the primary value entered in the first combo box. Don't know enough VB or any SQL to get this done. This would be the modern-day equivalent of an if-then statement in Basic (yes, that's the last programming code I learned). |
Thread Tools | |
Display Modes | |
|
|