I have a simple calender table and i have built a Data Access page that ask for a single date, that is suppose to call up a query. In the query is the orignal table that was talked about before. In the criteria section for date i have the following expression:

[Pages]![datelookupDAP]![caldate]

The user will pull up this DAP and enter a date which should excute the query and only show record that reflect that date. When i built this and ran it within Access exchanging [Pages] for [Forms], the system works perfectly.

But now when i run it from an a Data Access Page it does execute the query but now i get a dailog box asking for the criteria that is sitting in the DAP.

Please help - Thank you in advance.....

Scott