Data Access Page Help

[JasonPurdueEE]

Hello everybody. I dont exactly know where the best place to post this would be so I'll try here.

I need some help with a Data Access Page in Access 2000. I am trying to use a dropdown based off of a query. The query runs fine (I have tested it alone and in a form) but for some reason it wont allow me to set the ListRowSource for the dropdown in the Data Access Page to the query. It gives me the following error:

"The 'Query1' object can not be found."

Is there some other way I need to make reference to this query? Any body know what I'm doing wrong? Any help is greatly appriciated. Thank you.

JASON

 

[MMSantiago]

Try launching the page with a macro, where your dropdown query is run BEFORE the page comes up. Since the page does not directly use the query, it's probable that the field cannot be found because the query is never executed. Hope this helps.