Open blank form

[myxmaster]

Hello,
I have a form with a combobox that helps the user find a record. I
have noticed that when the form is re-opened it displays the last
record. What code do I need to insert to have the form open with blank
fields.
TIA

 

[John W. Vinson]

Hello,
I have a form with a combobox that helps the user find a record. I
have noticed that when the form is re-opened it displays the last
record. What code do I need to insert to have the form open with blank
fields.
TIA

Put some code in the form's Load event:

Private Sub Form_Load()
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub


John W. Vinson [MVP]