to run a report or open another from from a Combo box

[imtiaz1967]

I have attached a table of two column to a combo box, which is of different option for searches, i want, if i select 1 from combo, it should run a report, if two then open another form and and other combo, have more option for more other reports, i think, enough explanation

[Seth Schrock]

The way that I would do that would be to add two more fields to your table: ObjectType and ObjectName. Make sure to change the combo box's column count property to 4. Then in the combo box's AfterUpdate event, add the following (I use the name cboObject as the name of my combo box. Change it to what you have):

Select Case Me.cboObject
    Case "Form"
        DoCmd.OpenForm Me.cboObject.Column(3)
    Case "Report"
        DoCmd.OpenReport Me.cboObject.Column(3)
End Select