I have a form based on a query that I've developed over the past couple of days. When I first started, the form opened cleanly with no prompts needed. I could select my criteria, do a refresh and everything looks ok. The problem came when I selected new criteria, it wouldn't always update to the new record.
So, refresh became requery, and now it opens differently. When I open the form it prompts me for the three different criteria I've always needed for the query, and then opens up the blank form ready for me to then start selecting the necessary information. I want to suppress those three prompts on load.
Didn't find anything here with either supress or keep query form loading...
So, refresh became requery, and now it opens differently. When I open the form it prompts me for the three different criteria I've always needed for the query, and then opens up the blank form ready for me to then start selecting the necessary information. I want to suppress those three prompts on load.
Didn't find anything here with either supress or keep query form loading...