By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,518 Members | 1,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,518 IT Pros & Developers. It's quick & easy.

Multiple queries in a combo box

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.