Form Fields sort

[andybilge]

I want data from a Table to appear in a form field in alpha order. When I add a new record to my table I can easily sort into Alpha order but in the form field it comes up in record number order. Can this be changed?

Thanks

 

[bob fitz]

Use a sorted query as the Record Source of the form

 

[cyanidem]

Or, if you want to keep table as record source, set Order By property of form to your alphanumeric field and set Order By On Load to Yes.