Would like to see NEW Form.

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.....

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 procedu

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"sweetummy" wrote in message
...
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.....

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