Combo Box with multiple row source 1

[May2000]

Hi,

Need some help here. I am creating a Form with an Option Group (values 1, 2 & 3), A combo box wherein the row source changes (from Table1, Table2 & Table3) depending on the value of the Option Group. The selected text on the Combo box will the be used to filter the records on the Form.

Cna somebody show how to do this. I am just a beginner in VBA.

Thanks in advance.

May

 

[ClydeData]

Assuming buttons in your option group have data values 1, 2 & 3
You could use a select case statement in the after update even of your option group



Select Case Me.YourOptionGroup

Case 1
Me.YourComboBox.RowSource = "Table1"
Case 1
Me.YourComboBox.RowSource = "Table2"
Case 3
Me.YourComboBox.RowSource = "Table3"


End Select


Hope this helps

Jimmy

 

[May2000]

Thank you Jimmy for the quick response I will try this!

May

 

[dhookom]

You could also create a union query of tables 1-3 and use code or a filter to return only records from a subset of the union query.

Duane
Hook'D on Access
MS Access MVP