Losing records from a table

[Guest]

As I add additional records with the use of the form, I am losing records
from the beginning of the corresponding table.

 

[Rick Brandt]

As I add additional records with the use of the form, I am losing
records from the beginning of the corresponding table.

You are not adding records then. You are just changing the first record
every time.

Are you using a bound form?
Does it open at the blank "New Record" position?
If No, are you first moving to the new record position before entering your
data?

 

[Guest]

Rick, thanks for the reply, no the form doesn't open to a new or blank
record, it opens with the earliest record...I think you're on to
something...what do I do?

Bill

 

[Guest]

To enter a new record you should be clicking the new record button at the
bottom of your form, right?

 

[Roger Carlson]

In your OnOpen event, have the following:

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

This will go to the New Record each time the form is opened.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Guys, Thanks, this identified and fixed the problem! Appreciate it!!
Bill