Saving a record, and clearing fields

So one of my forms is to add a new record, which I can accomplish easy enough, however I was having trouble clearing the fields... at one point I went as far as to set each field to "" after I saved the record.

The problem here is that didnt create a new record, if I wanted to add another record it would go over the first save.

now Im using this:

Please Login or Register  to view this content.

is there a more elegant solution?

Keep in mind I dont want a blank record once the person gets done writing in new records... Im not sure if creating a new record after every button click would do that.... I was worried that I would always end up with 1 blank record at the end, which on the next time entering records would mean a blank record somewhere in the middle.... but not sure if it really works that way or not.

Anyway any help would be appreciated.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

If you bind your form to your table, and set the data entry line in the data tab of the form properties to NO, then you do not need a save button and every time you move to a new record, Access automatically saves the record. No need for messing with save or edit conditions. And this does not require any VBA.

Here is a link to a tutorial on setting up databases that you might find helpful.

http://www.accessmvp.com/strive4peace/