Form vs. table record order
Home > IT Answers > Database > Form vs. table record order
Mcoopers7
5 pts.
0
Q:
Form vs. table record order
Microsoft Access, Access forms
Why doesn't the record order for an MS Access form match the record order of the table (form keeps re-ordering the records)?
ASKED: Aug 6 2009  2:47 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Randym
1410 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
There is an order by property in the form. Possibly that is set? Or, the table's properties may have been saved after some one changed the sort order. Usually, the table opens with the ordering of the primary key. At any rate, if you want a specific order, set the order by property in the form or if the form uses a query as the record source, you could specify the ordering in there. If it uses a table for the record source, you could simply change the record source to: Select * From tablename order by col1, col2...
Last Answered: Aug 7 2009  2:58 PM GMT by Randym   1410 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0