CLEARING FIELDS WHEN ENTERING RECORD

[HerickP]

HI,<br><br>I have designed a form with 10 fields that will go into a table when I have filled them out and hit a command button button assigned to &quot;add record&quot;. No problem with that, except that when I open this form to add the records, for some reason, each textbox that it was bounded to fields in the table will show the first record of the table. if I hit the button to add the record, it will clear all the fields, but I would like to have the fields empty when I open the form, which is not happening...Any code for that??? and if not too much , any code for safe record entering, so I dont get duplicate records in my table??? Thanks

 

[DougP]

This is the way access is designed<br>If you are going to &quot;ALWAYS&quot; going Add a record when you come in. Then put the Docmd. in the form load<br><br>Private Sub Form_Load()<br>&nbsp;&nbsp;&nbsp;&nbsp;DoCmd.GoToRecord , , acNewRec<br>End Sub<br><br>Cause if you just blank the text boxes out will destroy your first record.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.