Form Question

[Guest]

I have created a form that updates data in a table. Each time I close and
reopen the form, it displays the data from the first recordn in the table. I
want the fields to be blank when the form is opened. Can someone tell me how
to do this please?

Paul

 

[John Vinson]

I have created a form that updates data in a table. Each time I close and
reopen the form, it displays the data from the first recordn in the table. I
want the fields to be blank when the form is opened. Can someone tell me how
to do this please?

Paul

Two ways:

1. Set the Form's Data Entry property to TRUE.

This has the disadvantage that the existing records will not be
visible, *ONLY* the new record.

2. Put VBA code in the form's Load event:

Private Sub Form_Load(Cancel as Integer)
DoCmd.GoToRecord, , acNewRec
End Sub

John W. Vinson[MVP]

 

[Guest]

Thanks John!

Two ways:

1. Set the Form's Data Entry property to TRUE.

This has the disadvantage that the existing records will not be
visible, *ONLY* the new record.

2. Put VBA code in the form's Load event:

Private Sub Form_Load(Cancel as Integer)
DoCmd.GoToRecord, , acNewRec
End Sub

John W. Vinson[MVP]