If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Form entry order
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 |
#3
|
|||
|
|||
Form entry order
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 |
#4
|
|||
|
|||
Form entry order
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] |
#5
|
|||
|
|||
Form entry order
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] |
#6
|
|||
|
|||
Form entry order
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 |
#7
|
|||
|
|||
Form entry order
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 |
#8
|
|||
|
|||
Form entry order
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 |
#9
|
|||
|
|||
Form entry order
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 |
#10
|
|||
|
|||
Form entry order
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 |
Thread Tools | |
Display Modes | |
|
|