Previously entered records are not accessable or display from the

W

wtrogers

I enter a record using a form. When I exit and enter the form again I cannot
access any record previously entered. The records are present in the table.
Each time I open the form the autonumber is "1" as if it's the first record
to be entered.

This form is a multi-tabbed form. I have created several forms for other
tables that are not multi-tabbed forms and I do experience this problem. It
only exists with this form.

I am using Access 2002 SP3
 
J

JulieD

Hi

is data entry property set to yes for the form (to find it, go into design
view ... click on view / properties .. ensure you're looking at the form's
properties) ... if so, set it to no, and you should see all your records.

if this isn't the case, could you please copy & paste the record source
information for the form.

Cheers
JulieD
 
W

Wendell

Problem solved. Thanks so much!

JulieD said:
Hi

is data entry property set to yes for the form (to find it, go into design
view ... click on view / properties .. ensure you're looking at the form's
properties) ... if so, set it to no, and you should see all your records.

if this isn't the case, could you please copy & paste the record source
information for the form.

Cheers
JulieD
 
Top