I need to create (code or macro) a button on my form that will revert all entries under one field on a subform back to "No".
I have a form with a search function in it. The user can search for various parts of an address or name and click search. The results are shown in the subform. In this subform there is an option for to "assign" an entry (or 10). The user will then select the entries they want and click the preview report button. The report only shows the entries that are switched to "yes". When they have printed their report I need the "yes" selections to revert back to no so the next user doesn't ahve a lot of "yes" entries messing up their choices.
Is this possible? Does somebody have an example database of how to do this?
I appreciate the help.
I have a form with a search function in it. The user can search for various parts of an address or name and click search. The results are shown in the subform. In this subform there is an option for to "assign" an entry (or 10). The user will then select the entries they want and click the preview report button. The report only shows the entries that are switched to "yes". When they have printed their report I need the "yes" selections to revert back to no so the next user doesn't ahve a lot of "yes" entries messing up their choices.
Is this possible? Does somebody have an example database of how to do this?
I appreciate the help.