Multiple queries in a combo box

[Luke Jones]

Hi

I have constructed five queries and I wish for these to be accessible
in a combo box.

Basically the queries are simple numerical manipulations and I require
to perfrom a search from the combo box depending on these queries and
then output in a form or report.

Thanks in advance,

Luke

[Keith Wilby]

lu***********@yahoo.co.uk (Luke Jones) wrote:

Basically the queries are simple numerical manipulations and I require
to perfrom a search from the combo box depending on these queries and
then output in a form or report.

Try using an If in the combo box On Click event.

If Condition1 = True Then Me.MyComboBox.RowSource = "qry1"
If Condition2 = True Then Me.MyComboBox.RowSource = "qry2"

etc.

Regards,
Keith.

[Ed Robichaud]

One simple solution is to make a table with the names of your 5 queries as 5
records in that table. Make your combobox with its record source that same
table. Make your form/report with its record source
"=Forms!myForm!cmbQueryChoice.rowsource0"
-Ed

"Luke Jones" <lu***********@yahoo.co.uk> wrote in message
news:24**************************@posting.google.c om...

Hi

I have constructed five queries and I wish for these to be accessible
in a combo box.

Basically the queries are simple numerical manipulations and I require
to perfrom a search from the combo box depending on these queries and
then output in a form or report.

Thanks in advance,

Luke