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
|
|||
|
|||
sincronized combo box
hi
i have two combo boxes 'category' and 'capacity' the data in first combo box 'category' is as follows category-A category-B the data in second combo box 'capacity' is as follows 200 300 400 500 the combo boxes take th values form the value list and not from any table/query and stores the data in to a table 'tblone' which has the following three fields sno -- is a autono category - text data type capacity - number data type here i would like the second combo box to show me 200 and 300 if i select the category-A in the first combo and the second combo must show me 400 and 500 if i select the category-B in the first combo i am an access beginner suggest me pls |
#2
|
|||
|
|||
sincronized combo box
hi Giripoduru
Put this code on the on change event OR afterupdate(i think) Private Sub catagory_Change() If me!catagory = "catagory-A" then capacity.rowsource = "200;300" Elseif Me!catagory = "catagory-b" then capacity.rowsource = "400;500" End if end sub Hope this helps Regan -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|