I have a continuous form that mirrors the data in a table1. It is used to amend table2 once table1 is set just the way I want. I would like to be able to click a button that would clear a short text field for all the 22 records in table1, as well as set a date field for all records in table1 based on a field on another form. Clear as mud?
Thanks