Thread: How do I change the order that my records appear in in Forms
View Single Post
  #2  
Old February 22nd, 2010, 01:01 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
  
Posts: 11,706
Default How do I change the order that my records appear in in Forms
Create a query.
Use the Sort row in query design to specify the sort order.

Choose this query in the RecordSource property of your form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Bethany.Ryan" wrote in message
...
I've entered all my data, but now I want it to be displayed in Forms in
order
by a specific field. How can I do that?