control source drop down not listing all queries...

B

Brad Pears

I am working on a report modifcation in Access 2000. I have some fields on
the report that have their control source based on an expression in a query.
I have many queries in this project...

When I click in the drop down to select the query I want, only so many
queries are listed. The one I want is not.

If I manually type in the query name.expression name, (similiar to other
fields I have on the report that work fine) and run the report, I get
errors - stating it cannot find the query./expression name I am using.

Is there some sort of a limit that can be displayed in that drop down and if
so, how can I get around it?? Since I need all my queries, I cannot delete
any...

Thanks,

Brad
 

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

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
MS Project Center-Autolink column fields 0
Can I save a sql statement generated by a search form? 1

Top