Not updating record number

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a data entry form, linked to a table and every time it is opened it
only show one record on the "record" line at the bottom of the form. The
user believesathat the data he has entered is not being saved. I assure him
it is but...

How to I correct this? This is the first time this has happened and I don't
know what I did??

Thanx
 
Is the form's Data Entry property set to Yes (Data tab on the form's
Property Sheet)? If so, try changing it to No. Data Entry mode allows new
records only.
 
A form with DataEntry set to YES only displays new records. Turn off the Nav
buttons.
 
Will this show the record numbers on the bottom of the form. That is what is
confusing the tech...
 
If you mean the "x of y" information that is included with the built-in
navigation buttons, that will show as 1 of 1 records if the Data Entry
property is set to Yes. A little experimentation would have revealed that
information. If the record counter is confusing the user, turn off the
navigation buttons, as suggested in another response to your original
question.
 
What you are experiencing is why I never show the nav buttons and use my own.
Users and even some newbie developers don't understand the record number
thing. In FoxPro, records do have a presistent record number, but not so in
Access. The number you see is only a relative position in the current
recordset. If you filter the form, change the sort order, add records, or
delete records, the numbers will change. Access databases do not have record
numbers.
 
Back
Top