I have created a page which captures the data in tables. My page has Name, Address, etc. I want a button on my page that when you click on it, if a user fills out all their details but has made a lot of mistakes... instead of going into name, address, and so on and clicking on the backspace button, I want a button that just resets everything.
'For bound forms BEFORE submition
'For unbound forms simply clear the textbox controls
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
ctl.value = ""
Unbound - not directly linked to a data field on a table
Bound - when you enter a value and move the cursor to another field the data is entered. Resetting these fields to " " might not be a practical solution.