combo box queries

[gaget]

I have a combo box that displays the numbers 0-3. All of these numbers are
linked to only one query within the rowsouce that displays a specific table.
I am trying to get get a different query to be used so when the #3 is
selected it displays a different table. Can anyone help me?

 

[fredg]

I have a combo box that displays the numbers 0-3. All of these numbers are
linked to only one query within the rowsouce that displays a specific table.
I am trying to get get a different query to be used so when the #3 is
selected it displays a different table. Can anyone help me?

It's not very clear as to what you are trying to do.

As a guess, you wish to change the rowsource of a query from one query
to another if the value 3 is selected?
The value must be in the combo box's bound column.

Code the Combo Box AfterUpdate event:
If Me.ComboName = 3 Then
Me.ComboName.Rowsource = "NameOfQuery"
End If

Now how do you intend to get the previous rowsource back?