FORMS - sorting data in tables.

[eaglei66]

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

 

[Pat Hartman]

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.

 

[eaglei66]

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

 

[Pat Hartman]

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.