G Guest Apr 22, 2004 #1 I would like to be able to open another form based on the selection from a drop down list, can anybody help Many thank Mark
I would like to be able to open another form based on the selection from a drop down list, can anybody help Many thank Mark
G Gerald Stanley Apr 22, 2004 #2 In the list box's AfterUpdate eventhandler, put in code similar to Dim strFormName as String Select Case listControl.Value Case "value1" strFormName = "someFormName" Case "value2" strFormName = "anotherFormName" Case ...... End Select DoCmd.OpenForm strFormName You will have to put in your own dropdown values and the corresponding form names. Hope This Helps Gerald Stanley MCSD -----Original Message----- I would like to be able to open another form based on the Click to expand... selection from a drop down list, can anybody help?
In the list box's AfterUpdate eventhandler, put in code similar to Dim strFormName as String Select Case listControl.Value Case "value1" strFormName = "someFormName" Case "value2" strFormName = "anotherFormName" Case ...... End Select DoCmd.OpenForm strFormName You will have to put in your own dropdown values and the corresponding form names. Hope This Helps Gerald Stanley MCSD -----Original Message----- I would like to be able to open another form based on the Click to expand... selection from a drop down list, can anybody help?
