Access form won’t clear after each entry is added
I have an access form with an add button. The button adds the record to the table, but the form won't clear that entry out. How do I clear the entry?
Software/Hardware used:
Software/Hardware used:
ASKED:
September 3, 2008 9:30 PM
UPDATED:
September 26, 2008 7:58 PM
Answer Wiki:
You could reate a "New Record Button" on the form using this code:
<pre>
Private Sub Command20_Click()
On Error GoTo Err_Command20_Click
DoCmd.GoToRecord , , acNewRec
Exit_Command20_Click:
Exit Sub
Err_Command20_Click:
MsgBox Err.Description
Resume Exit_Command20_Click
End Sub
</pre>
Or you could put this code at the end of the code of the button you already have, to automatically clear the form after adding the record to the database.
This <a href="http://bytes.com/forum/thread660680.html"> site </a> has an interesting discussion dealing with the exact same issue that you have. You might find it helpful.
Good Luck
-Flame
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
