I have a continuous form, in a subform, with four fields in it. The first is an alpha-numeric code always starting with a letter. The second is a description field. The third and forth are date fields. I just noticed that after data entry the form sorted by the alpha numeric code which is totally incorrect. It should sort by data entry order. In most cases that would be the first date field, but not necessarily. I created this form some time back, but never noticed this until now. I may have done something to alter the sort, but I'm not sure. How do I get this back to sorting in data entry order. I'd rather not change the structure of the table by adding an autonumber field, but I could, necessary.
Thanks in advance.
Paul