I usually use the following code on a "clear" button to remove data entered on a normal, bound form..
Private Sub cmdClear_Click()
If Me.Dirty Then Me.Undo
End Sub
The problem is I have an unbound form I am trying to do the same thing with and I get the following error when pushing the "clear" button (using the same code).
run-time error 2455...you entered an expression thet has an invalid reference to the property Dirty.
How do I remedy this and/or if I have an update button that populates a table with data I just entered on this unbound form, how do I clear the form for the next set of entries (maybe even show a message box that states the data has been entered to the table)? [sig][/sig]
Private Sub cmdClear_Click()
If Me.Dirty Then Me.Undo
End Sub
The problem is I have an unbound form I am trying to do the same thing with and I get the following error when pushing the "clear" button (using the same code).
run-time error 2455...you entered an expression thet has an invalid reference to the property Dirty.
How do I remedy this and/or if I have an update button that populates a table with data I just entered on this unbound form, how do I clear the form for the next set of entries (maybe even show a message box that states the data has been entered to the table)? [sig][/sig]