Form sort Sequence

[jrmbach]

I have a table which contains an Auto Number field(Record Key) and, among other fields, an "Effective Date" field. I create a Form using that Table. After I have entered data into the Table using that Form the forms are in sequence by the Record Key. I want to scroll thru the forms sorted by "Effective Date". How do I change the sort sequence of the forms?

[Bob Fitz]

Set the forms "Order By" property.