Subform counts records in reverse order

[FJ Questioner]

I have a subform which records entries in reverse order. For example, I enter
record number 1 then click the right arrow to go to the next record entry.
However, instead of advancing to record 2, it goes to a blank record 1,
meanwhile the first record I entered is now record 2.

If I enter a new record and click the right arrow, the origianl entry is now
record 3, the second entry is record 2 and I now have a blank record 1 ready
for entry.

How do I reset this so that it counts the records normally (as all my other
forms do)?

Thanks,
FJ

 

[Jeff Boyce]

Tables don't have any inherent (human understandable) order. Just because
your subform displays your records in the order you described doesn't mean
Access thinks of them that way.

If you want Access to follow a particular order, you have to tell Access
which record is in which order (i.e., a "sequence" field).

If you are referring to the "record number" in the lower left of the form,
that is NOT a record number, that is just a count of records being displayed
in the form with whatever filter has been applied. Change the filter, get
new "record numbers". Change the sort order, get new "record numbers".

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[FJ Questioner]

Thanks. Its the record numbers in the lower left that I was referring to.
However I don't really follow what you mean about changing the filter and/or
sort. Which one applies and how do I do that (presumably within the
properties of the Form?)
Thanks,

FJ

 

[Jeff Boyce]

The "record number" is not real. It is only a count of displayed records.
If you display a subset of that same table (for example, by using a filter),
you will see a DIFFERENT number of records. If you sort the records in that
table a different way, you will see DIFFERENT "record numbers".

Access records do not have inherent "record numbers". That's up to you to
add a field and store a ("sequence") number, if you want to use/display one.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[FJ Questioner]

I'm not sure we're talking about the same thing. Maybe I shouldn't be using
the word "record". I'm referring to the numbering system of the form pages
in the bottom left corner of a form page. I have numerous forms and in all
cases but one, when I open a new form to enter data it shows as form page 1.
When I click the right arrow at the bottom left of the page to go to a new
form page, the new form page shows as number 2 etc... However, with this
one form when I click the arrow the new blank page shows as number 1 and the
one I filled out previously as page number 1 now shows as form page number
2. If I end up entering 10 form pages, the first one is now called number
10, the second is number 9 etc... Its really annoying to try to use when
everything is laced in reverse order.

I have no idea why it does that since I have at least 30 different forms in
my program and none of the others do that.

Thanks,
FJ

 

[Jeff Boyce]

So you're saying that this behavior only happens on one of your forms?

It almost sounds like that form is set for data entry.

But the number that appears in the bottom left is still only a count, not a
record number. Even if you're using a form. Remember, a form only displays
records from a table (or a query).

Check the properties of the form in design view and see if this form uses
different settings for Data or similar properties.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[FJ Questioner]

Yes I only have the problem on this one for.
Data Entry is set to NO.

I just noticed something else. The form in question is actually a subform
within another form. If I open the subform by itself, the counter system for
the form pages appear in the proper sequence. However, when the form is
opened as actually used within the system (ie. as a subform of another form)
then the counter system reverses as described.

I checked the Properties for the Form page with the properties of other
forms and didn't notice anything particularly strtange although obviously
I've missed something.

Any ideas as to what might be causing this anomoly? I'm stumped...

FJ

 

[Jeff Boyce]

Me too...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/