Order of records

[akirk]

I have a form used for data entry by 2 people based on a table. Until yesterday, the form was set up so that the first record was record 1, and the form showed each record in ascending order. Yesterday, the form started showing records in a seemingly random order.

The order is correct in the table, and as far as I can tell, the primary key in the table is still the auto number which provides the record number.

Any idea how to fix this form so that the records are back in numerical order?

Thanks

kirk

 

[jrbarnett]

Things to check on form properties:
1) see if anybody has set the OrderBy property or turned OrderBy on.
2) see if filters have been set up to limit the records displayed.
3) If the form is based on a query which is based on a table, have they added an ORDER BY clause to sort it in a different order, or changed a previous one?

John

 

[SMerrill]

Forms have a .Filter and a .OrderBy property. These properties are set by the user when they click on the SortAscending, SortDescending toolbar buttons or on the FilterBySelection buttons. The settings can be inadvertently saved when, upon exiting the form, the form asks if you want to save changes. The hidden meaning is "do you want to save design changes" but Microsoft doesn't tell you this. So, thinking they are saving data changes, the user selects YES.

The user can un-press the ApplyFilter tool to remove these changes, or as the designer, you can prevent them from being saved in code, as follows:

When you close the form from code, be sure to use

DoCmd.Close _
  ObjectType:=acForm, _
  ObjectName:="Form Name", _
  Save:=

acSaveNo

--Shaun Merrill

 

[akirk]

Great found the problem--thanks for the help.

kirk