Form entry order

I have a subform which records entries in reverse order. (I am referring to
the record number in the bottom left corner of the form).
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 original entry is now
record 3, the second entry is record 2 and I now have a blank record 1 ready
for entry.

I only have pne form (subform actually) that does this. All the others work
properly.
How do I reset this so that it counts the records in regular sequence?

Thanks,
FJ

FJ,
Open the Recordsource property of the subform you are referring to. From
our description it seems like the field may be sorting in Desending order.
If so. change it to blank or Ascending order.

God Bless,

Mark A. Sam


"FJ Questioner" wrote in message
...
I have a subform which records entries in reverse order. (I am referring to
the record number in the bottom left corner of the form).
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 original entry is
now
record 3, the second entry is record 2 and I now have a blank record 1
ready
for entry.

I only have pne form (subform actually) that does this. All the others
work
properly.
How do I reset this so that it counts the records in regular sequence?

Thanks,
FJ

Well, the record source for the subform is a query......

Does that make any sense?

FJ


"Mark A. Sam" wrote:

FJ,
Open the Recordsource property of the subform you are referring to. From
our description it seems like the field may be sorting in Desending order.
If so. change it to blank or Ascending order.

God Bless,

Mark A. Sam


"FJ Questioner" wrote in message
...
I have a subform which records entries in reverse order. (I am referring to
the record number in the bottom left corner of the form).
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 original entry is
now
record 3, the second entry is record 2 and I now have a blank record 1
ready
for entry.

I only have pne form (subform actually) that does this. All the others
work
properly.
How do I reset this so that it counts the records in regular sequence?

Thanks,
FJ

On Mon, 5 Jan 2009 11:06:01 -0800, FJ Questioner
wrote:

Well, the record source for the subform is a query......

Does that make any sense?

FJ

Yes. Follow Mark's suggestion and *fix the error in the query*.


"Mark A. Sam" wrote:

FJ,
Open the Recordsource property of the subform you are referring to. From
our description it seems like the field may be sorting in Desending order.
If so. change it to blank or Ascending order.

--

John W. Vinson [MVP]

The record source query has about 30 fields. All but one have no sort
associated with them. ONe is sorted ascending so I switched that to
descending but it made no difference.

One other thing I should mention, 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 SubForm page with the properties of my other
forms and didn't notice anything particularly strange (although presumably
I've missed something ?).

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


"John W. Vinson" wrote:

On Mon, 5 Jan 2009 11:06:01 -0800, FJ Questioner
wrote:

Well, the record source for the subform is a query......

Does that make any sense?

FJ

Yes. Follow Mark's suggestion and *fix the error in the query*.


"Mark A. Sam" wrote:

FJ,
Open the Recordsource property of the subform you are referring to. From
our description it seems like the field may be sorting in Desending order.
If so. change it to blank or Ascending order.

--

John W. Vinson [MVP]

Since it is a subform on a form, you may want to double check that the
form that it is on is not dynamically assigning a orderby to the
subform. On open, OnLoad, OnCurrent are the typical places for this to
occur, or possibly some button on the form may also do it.

Ron

The form that holds the subform does have an event On Open which sets it to a
New Record. I tried changing that to Next Record but it made no difference.
The subform itself has no events on open, on load or on current. The
bizarre thing is that when I look at the underlying table for the subform,
the records are in proper sequence but when I use use the subform to look at
those records, the subform number sequence is reversed. Each subform page
represents an invoice. So for example suppose I was starting fresh with a new
database. If I enter three invoices they'll show up on the underlying invoice
table as records 1,2,3 yet when I view those invoices within the subform they
show up on the subform counter in the bottom left as 3,2,1.

Each time I enter a new invoice ion the subform, the new invoice is assigned
number one, the one before is number 2 etc...

I have no idea what's causing this. Can you think of anything that might
be doing this?

Thanks,
FJ


"Ron2006" wrote:

Since it is a subform on a form, you may want to double check that the
form that it is on is not dynamically assigning a orderby to the
subform. On open, OnLoad, OnCurrent are the typical places for this to
occur, or possibly some button on the form may also do it.

Ron

Which version of Access?

A new feature. Of course if we don't know what is triggering it, it is
not too much of a feature.

Ron

I'm using 2003 !

"Ron2006" wrote:

Which version of Access?

A new feature. Of course if we don't know what is triggering it, it is
not too much of a feature.

Ron

Is this an app that you wrote? If it is someone else's work, there may be
something in code causing this, like Ron suggested. But here is another
possibiilty. Somone may have set the Sort Order using the short cut menu on
the form. On the main form and subforms right click and select "Remove
Filter/Sort. Someone may have inadvertantly saves the changes after
sorting.

God Bless,

Mark