Select Query Access V.B. Question

[Rich]

Hello all,

This might such a simple question, I am just overlooking the obvious. I
have three select queries defined in an Access DB (i.e. qry1, qry2,
qry3) that each have different sets of orders and fields.

What I am trying to do on a form is use an option group with three
option radials and depending on which one is selected, a combo box
displays the data for that option group selection (using one of the
three queries defined above).

I have it working by using the actual SQL statement in the VB code (i.e.
combobox.rowsource = "SELECT ....", but I would like to just assign
the combobox.rowsource to one of the three named queries. Is there any
way to do this?

It seems obvious, but I don't know how to get to the query SQL info
(i.e. form name use FORMS!xxx) to assign it to a string var.

Thanks in advance,
RJC

 

[Allen Browne]

Did you try assigning the name of the query to the RowSource of the combo?

In the AfterUpdate event procedure of the option group, do something like
this:
Private Sub Frame1_AfterUpdate
Dim strQry As String
Select Case Me.Frame1
Case 1
strQry = "qry1"
Case 2
strQry = "qry2"
Case Else
strQry = "qry3"
End Select
Me.Combo1.RowSource = strQry
End Sub