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