Form displays records not in index order

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have a table that is indexed on a vendorId number.
There is a form that is set to display every record in the
table. However when that form is opened the first record
displayed has an index number of 15. the following then
displays 16, 17, 18, and then starts at 1. (there are 24
records currently in the table) I tried entering in the
form properties Orderby vendorID. this makes no
differance. How can I get this form which has to look at
every record in the table, thus no need for a query, to
sort on the vendorID?
 
You will also need to set the OrderByOn property to True by inserting the
following code in the form's Open event:

Me.OrderByOn = True

Or, dispense with using OrderBy and OrderByOn by making your form's
RecordSource a query on the entire table with an ORDER BY clause.

hth,
 
Back
Top