order forms by date record created

[Annie1904]

I enter my records on a form. I also use the form to retrieve individual
records. I have a combo box to look up specific records, but sometimes I
just want to flick through (using fwd/back keys) to see those most recently
created. I can't seem to get them to appear in date order.

I have a field 'Date received' in both the table and form and this is the
field I would like to order my forms by. There's an 'order by' option in the
form properties box. There's no drop-down arown, or build function next to
this - what do I type in? Or is there another way to do this?

 

[Douglas J. Steele]

Create a query that sorts the data as you want it, and use the query as the
RecordSource for the form, rather than using the table.

 

[Annie1904]

Thanks, Douglas, this did work. A.

Create a query that sorts the data as you want it, and use the query as the
RecordSource for the form, rather than using the table.