combo box queries

G

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?
 
F

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?
Click to expand...

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?
 
J

jversiz via AccessMonster.com

So what displays a different table, another part of the form, or another
combo box?

Regards,
James C.
 
Top