I have an unbound form that I enter a range of numbers (and other data) to populate a table. I use a command button to populate the data. When the button is pushed, how do I get the form to clear, so I can enter the next range of data?
I used to write code for another command button to clear a form (but those were bound forms). Here is the code I used
Private Sub Command_Click()
If me.dirty then me.undo
End Sub
This code does not work for the unbound form. What do I need to do?
Thanks in advance [sig][/sig]
I used to write code for another command button to clear a form (but those were bound forms). Here is the code I used
Private Sub Command_Click()
If me.dirty then me.undo
End Sub
This code does not work for the unbound form. What do I need to do?
Thanks in advance [sig][/sig]