WHY DO MY RECORDS MOVE IN MY SUBFORM?

[Guest]

i have a records form with a subformof recordsthat will post to it if i
create an invoice or purchase order. it will automatically create a new line
for the next new record.
Question: sometimes but not all the time if i manually enter data on the
subform record the record will move up the datasheet like 25 records even
though the date is the first item entered on the line.
Shouldn't the date always remain in sequence? this drives me crazy trying to
find new records in older date lines?

 

[Douglas J Steele]

Never make any assumptions about the order of records in tables. Unless your
form is based on a query that has the appropriate ORDER BY clause, what's
returned to you is essentially going to be random.

 

[Guest]

Thanks, Doug.

Is there a way that I can fix this problem?
Pat

 

[Douglas J Steele]

Base your form on a query that has the appropriate ORDER BY clause.