Adding Records

C

Chinny03

I just started creating a database. I made a table and started entering the
data using the Datasheet view. Once I was done putting all the records in.
I made a form that the user would enter all the appropriate data and click
the add record button. The problem is that the record is added to the table.
However, the first record of the table is gone. I have no idea why this is
happening. Any help would be greatly appreciated.
 
D

Daniel

When you used your form, was there data displayed in it? If so you
over-wrote the entry. you need to make sure that you are on a blank record
before making new entries otherwise you are actively modifying the record
displayed.

At the bottom of your form there should be navigation buttons. The far
left-hand one (arrow with a star) will bring you to a new blank entry to add
a new record.
 
C

Chinny03

This helped. Thank you. Is there a way you could still add records without
hitting the navigation before entering records?
 
J

John W. Vinson

I just started creating a database. I made a table and started entering the
data using the Datasheet view. Once I was done putting all the records in.
I made a form that the user would enter all the appropriate data and click
the add record button. The problem is that the record is added to the table.
However, the first record of the table is gone. I have no idea why this is
happening. Any help would be greatly appreciated.
Click to expand...

One possible explanation is that you may have set the form's Data Entry
property to Yes. This property is a bit confusing - its effect is that you can
ONLY enter new records, not see existing ones.

Check the Table - I suspect that the records are still there, just not
displayed on your form. To have the form display them turn off the Data Entry
property.

John W. Vinson [MVP]
 
Top