Saving Information, but clearing the form

[internintrouble]

I have a form for employees to fill out that includes the date, different sections of information that must be stored and their initials.

I have a table for the information to be stored and the first entry will store okay, but then when i try to access the same form for another entry, it isn't blank.

Missing something?

 

[rainman89]

you can set the form so that it opens to a new "blank" record automatically! or you can create a button on the form to create a new "blank" record.

DoCmd.GoToRecord , , acNewRec

 

[shuff]

If you're opening the form with a macro, use the Data Mode argument within the OpenForm action. Set it to "Add" and the form will always open in Add A Record mode. If you sometimes want to use the same form for reviewing existing records, then use a different macro and set the same setting to "Edit" or "Read Only" depending on what you want.

Scott