FORMS - sorting data in tables.

eaglei66

New member
Local time
Today, 12:34
Joined
Feb 4, 2003
Messages
5
Hello again.
One more question.

In my form i would like my lookup table to resort them selves ascending after exiting the field. is this possible? right now after a new item is added and after a not in list sub routine, and i goto a new record entry all of my lookup tables are not sorted and everthing added during that session is listed at the bottom of the data, then i have to physically go sort the table and save it. is there a way to fix this as stated above??

please help.

Eaglei66
 
You need to use a query with an order by clause as the rowsource rather than the table and you need to requery the combo after you add a new record.
 
still one problem

i figured out one fix by using the DATA row source in the form and chose ascending an it is working just fine now. Perfect in fact.


But i do still have one field in my form that i don't want sorted and it still sorts it no matter what i do. i chose do not sort but it still sorts the fields from one data entry recordset to the next.

any way to stop this???


eaglei66
 
You say that you don't want the recordset sorted yet you don't like the order it is in. That tells me that you DO want it ordered. The question is, what do you want it ordered by? Usually this means that you want the rows in data entry order. Well the only way to achieve that is to use an autonumber as the primary key and sort by the autonumber. That will return the rows in the order in which they were entered.
 

Users who are viewing this thread

Back
Top Bottom