The problem I have is this when i test a query in the datasheet preview they work no problem. But as soon as i put the query in to a form or a report. I get a prompt box asking me to enter a parameter value. If I click ok without entering any thing. It go to the report or from and work fine.
Example i have simple query that is just a stock list. Just list a few fields rather then all the full list of field of the table. No input needed, other than clicking on the preview report. WHAT am i missing or doing wrong.
Example i have simple query that is just a stock list. Just list a few fields rather then all the full list of field of the table. No input needed, other than clicking on the preview report. WHAT am i missing or doing wrong.