I've created form that auto-populates all fields through the completion of the Last Name field. I've included a reset report button that has a rule that clears all form fields when clicked.
This rule works, except the previous last name chosen stays in the Last Name unique field, and only it or blank can be chosen.
I need for the form to clear all fields, and the names in the Last Name drop-down field made available for a new query, as if a new form has been opened.
On-line instructions recommend the following. I'm not sure how or where to accomplish No. 2 below.
1. Reset all query fields used to blank
2. Reset the query ID field of the data connection used to zero
3. Perform a query for data operation against the data source
4. Reset the query ID field of the data connection to blank