Would like to see NEW Form.

[sweetummy]

hi,
I have created database with 100 's of records..
When opened it shows my first record every time .

I would like to see a new form to append to all those records..

Eg: 100 records saved in database and i exited from access.

after opening it show me 101 record to enter.....

 

[Allen Browne]

A simple solution is to set the form's Data Entry property to Yes. Then
Access won't load the existing records, so you will be at a new record each
time you open the form.

If you want to load the old records so the user can step back to them
(navigation buttons), put this code into the form's Load event procedure:

Private Sub Form_Load()
It Not Me.NewRecord Then
RunCommand acCmdRecordsGotoNew
End If
End Sub

 

[sweetummy]

Thank you very much browne.. and you have given me a bonus of
(Thousand tips) website..
allenbrowne.....