Reset Fields After Button Click

[Eranka]

Hi Every One

Private Sub Text3_Change()
Command1.Enabled = True
Command1.Caption = "Save Lecturer ID " & Text1.Value
Text1.Value = ""
Text2.Value = ""
End Sub

I Have a Save button in my program(used wizard to save the text's), when i enter a value into my last text box( text3) my button enables. then i click on save.
Now what i want to do is to reset the text boxes after i hit save button. I tried above code but it changes clears the text boxes before i hit the Save button. Can you help me on this?

[orange]

If you are working with a button Click event, why are you showing a Change event?
What are you trying to do in plain English?

[Eranka]

For example when i type "Employee ID" in my 1st text box then only the second text box enables and when i enter a text into my second text box it enables the save button.

And i did not code for button click event, i used the default function in access.

How do i clear the textboxes after i hit the save button.

[orange]

You don't need to explicitly save a record in Access. Access will save a record when you move to another record.

Your post title is

Reset Fields After Button Click

??

[Eranka]

Yeah i want to reset the fields after the button click. how to do it?

[orange]

Here is a sample code I found via Google

 Private Sub resetbtn_Click()  ' replace resetbtn with your button's name

 Me.clientname = ""        'Me refers to the current form and the items following the dot are controls on the form
 Me.operatingstate = ""
 Me.product = ""
Me.Refresh                     'refresh the form using the new vales (resetting) the controls on the form

End Sub

[June7]

Are these bound or unbound controls?

If controls are bound, then 'resetting' will delete data from record. Possibly what you should do is just move to a new record row.

Refresh will do nothing to requery comboboxes.

[Micron]

but it changes clears the text boxes before i hit the Save button.

because the change event fires before you can ever get to the button click. The last post re bound fields is crucial - don't overlook it. Don't entirely agree that navigating to or making a different record the current one is always the way to go. Sometimes the user needs to save progress in order to generate related data, such as a document/invoice/record number without leaving the record on the active form, but navigation is often simple enough, as is closing the form, which will also save the current record.