Clear form for next record (MS Access 2007)

[pwalter83]

Hi,

I have created a form which uses both textboxes and a combobox. What I wish to achieve is that once the user has entered a data and clicked on save button, the previous entered data should clear out from all the textboxes and the combobox.

I have tried everything but it does not seem to work. Even the command below does not work:

DoCmd.GoToRecord , , acNewRec or

Any suggestions would be appreciated. Please also find the form attached. The name of the form is Register Vessel.

Thanks,
Paul

 

[missinglinq]

Is this Form in question Bound to a Table or Query?

Linq ;0)>

 

[NickHa]

From what I can see of your code, it appears that you are working against the principles of bound forms. Your Add_Record_Click event is using SQL INSERT to add the form data to the table to which the form is bound, which is not necessary. There is no need for any DoCmd functions in your application in this context. I can't see the full context because your DB is upsetting my PC. I noticed that one of your form fields is unbound, so anything entered into that will be lost.