Form entry order

[FJ Questioner]

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

 

[Mark A. Sam]

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]

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

Does that make any sense?

FJ

 

[John W. Vinson]

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*.

 

[FJ Questioner]

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...

 

[Ron2006]

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

 

[FJ Questioner]

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]

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

 

[FJ Questioner]

I'm using 2003 !

 

[Mark A. Sam]

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

 

[FJ Questioner]

Mark,
Thanks for your help with this.

Yes I wrote the app a couple of years ago.

I tried your suggestion on the remove filter/sort but to no avail......
Every time I enter a new invoice on the subform and click the bottom left
arrow to go to the next entry form, the form I just entered becomes form 1.

FJ

 

[Mark A. Sam]

Arrow to go to the next form? I think I misunderstood the problem. Is the
arrow a button?

In the click event of the button do you have a method: Me.Requery or
Form.Requery? Maybe somewhere else in code? That would cause the form to
go to record 1. I could open an event procedure and do a search on
"requery" (without quotes) and see if it is being executed sometime after
you click the arrow.

 

[FJ Questioner]

No its not a button. I was referring to the genereic part of all forms in the
bottom left corner which shows the form number and has arows to go left or
right or the beginning or end of the series.

FJ

 

[John W. Vinson]

No its not a button. I was referring to the genereic part of all forms in the
bottom left corner which shows the form number and has arows to go left or
right or the beginning or end of the series.

THAT IS YOUR PROBLEM.

You're misinterpreting what that number *means*.

That number

*is not a form number*.

That number is not a record number.

That number is not stored ANYWHERE in your tables.

It's merely a dynamic indicator of the current position being displayed in the
form's recordsource query. It isn't associated with any particular record.

 

[FJ Questioner]

Yes I know that the number is not the record number in the underlying table
and isn't a stored value.

However, I'm not concerned about this problem with respect to the integrity
of the underlying tables. I'm looking at this from a user data entry point
of view. Its a real pain when the form reverses the entry order.

Doesn't it seem strange that the "dynamic indicator of the current position
being displayed in the form's recordsource query" goes in regular sequential
order for every form in my system but one ?

Thanks again,
FJ

 

[Larry Linson]

That doesn't "go to a new or another Form", it is "Record Navigation" and
moves from one Record in the Record Source to another on the same Form.
It's is worth learning the terminology of your tools when you rely on remote
assistance.

Larry Linson
Microsoft Office Access MVP

 

[FJ Questioner]

Right. Thanks for the clarification. Its the record navigation number that
is reversing for some reason. Have you any idea as to what may be causing
that?
Thanks,

FJ

 

[John W. Vinson]

Right. Thanks for the clarification. Its the record navigation number that
is reversing for some reason. Have you any idea as to what may be causing
that?

FJ, would you be willing to zip up this database and email it to me at jvinson
<at> wysard of info <dot> com? I've been watching your requests for weeks here
and I still don't understand what's happening or why. If the database is large
or confidential, could you perhaps import this form into a pared-down test
database?

For that matter - have you tried recreating the form from scratch? Maybe it's
a subtly corrupted form, and Compact and Repair doesn't fix it.

 

[FJ Questioner]

I sent the zipped file to you at (e-mail address removed) on Jan 10.

Just wanted to make sure you got it.

Thanks.

FJ

 

[John W. Vinson]

I sent the zipped file to you at (e-mail address removed) on Jan 10.

Just wanted to make sure you got it.

I did... I've been under the weather and haven't had a chance to look at it.