List of query on form

R

rblivewire

I have made a combo box that shows all of the queries I have built on
the form, but when I try to click on them it gives me nothing. Is
there a way to have a user click on the query and it show the results
form that query.

I have this in the rowsource of the combo box: SELECT Name FROM
MSysObjects WHERE Type=5 AND LEFT$([Name], 3) <> "~sq" ORDER BY Name

And this in the AFTERUPDATE: DoCmd.OpenQuery Me.Combo24,
[acViewNormal], [acReadOnly]

Anything wrong??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query problem 2
Combo or list box 0
QBF & Query Malfunction 0
combo box selection runs query to sum values in table not gettingparameter from combo box 2
my combo boxes 2
how to requery on new record continuous form 1
'Go to Record' button - simple task but can't get it to work 1
Form that Runs a Query. 8

Top