Form w/ combo box from query based on lookup field not alphabetizi

[Karen]

I have a query that includes a lookup field (combo box). I included an ORDER
BY clause in the query for the lookup field. The field sorts the lookup list
alphabetically and in the query. I'm happy with that.

I created a main form w/ a linked form based on the query. The linked form
contains the lookup field. However, the lookup table is still not
alphabetised.

Why? Please help in alphabetising the field on the linked form. All help
is prematurely appreciated.

 

[Wayne-I-M]

Table sorting is VERY strange - I think Bill Gates understands it and no one
else without a MVP somewhere in the line

Best bet would be to create a query from your table and base the form on
that. Sort the query how you want.

 

[Karen]

I went into the subform and verified data in row source - all of a sudden it
works perfectly!

 

[Wayne-I-M]

and verified data in row source

Is this an On-Line database ??

 

[Karen]

No.
--
Thanks, Karen

Is this an On-Line database ??

 

[Wayne-I-M]

The reason I asked is that on many on DB's you do need to verify the data
for each field to upload to the on-line DB

Oh well I'm glad you got it working - I would still base the form on a query
though,

Good luck