Having option1 as Optiongroup and CC as ComboBox:
select case option1
Case 1
CC.RowSource = "TableName1"
CC.ColumnCount = 2 'Number of columns allowed
CC.BoundColumn = 1 'Column linked
CC.Requery
Case 2
CC.RowSource = "TableName2"
CC.ColumnCount = 2 'Number of columns allowed
CC.BoundColumn = 1 'Column linked
CC.Requery
end select