Need Help Linking?

G

GoBrowns!

I have a query which stores all relevant data. The dates that the query
returns are contingent upon:

Between [Forms]![Reason_Code_Report_Form]![Beginning Date] And
[Forms]![Reason_Code_Report_Form]![Ending Date]

The form "Reason_Code_Report_Form" asks the user to input a Beginning and
End date, then run the report.

It doesn't work!

If I bypass the form and type the beginning and ending dates into the pop-up
boxes, the report works. I think there is a problem with the form. Does it
need to be linked to something (query or the report) in order to work?

Thanks for the help - will provide more details if necessary.
 
K

KARL DEWEY

I have a query which stores all relevant data.
Queries do not store data, only retrieves data from tables.
I have never seen where a form 'ask' for data or prompted for input. A
query will prompt for input if there is an object it can not find.
What does not work? What are the expected and actual results?
There probably is a typing difference between the form name, form text box
names and that used in the query. Check for exact matches.
 

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


Top