Shared Data Entry - Sorting ?

[sheyde]

I have a simple database - that is now being used as a shared database with multiple users. I have a form with a subform. When you search for a record of "Joe Blow" and the subform has 20 records - those 20 records are jumbled. I made sure when the entry people inputted data that they enter a date field for each record.

How do I get this database to sort the subform by date and then by an incrimental ID field so that the next time someone searches for "Joe Blow" all 20 records will be in order?

 

[AlaskanDad]

Set the Order By property of the subform to

[YourSubFormsTable].[YourDateField]

That'll do it.