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
|
|||
|
|||
Drop down boxes
Hi,
I am trying to figure how to display a drop down box in a form, and when something is selected from that drop down box, that another corresponding drop down box appears with the options available from the original selection. Does anyone know how to do this??? |
#2
|
|||
|
|||
Drop down boxes
On Wed, 10 Sep 2008 08:56:01 -0700, Steve wrote:
Hi, I am trying to figure how to display a drop down box in a form, and when something is selected from that drop down box, that another corresponding drop down box appears with the options available from the original selection. Does anyone know how to do this??? Leave the rowsource of the 2nd combo box blank. Code the AfterUpdate event of the 1st combo box to fill the rowsource of the 2nd. Something like this: Combo2.Rowsource = "Select Instructors.InstructorID, Instructors.InstructorName from Instructors Where Instructors.ClassID = " & Me!ComboName & ";" Change the table and field names as needed. The above assumes ClassID is a Number datatype and the combo box bound column is Number also. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Drop down boxes
Search on Cascading Combos.
-- KARL DEWEY Build a little - Test a little "Steve" wrote: Hi, I am trying to figure how to display a drop down box in a form, and when something is selected from that drop down box, that another corresponding drop down box appears with the options available from the original selection. Does anyone know how to do this??? |
Thread Tools | |
Display Modes | |
|
|