Changing the display order on form of records in tabular display

[jpl458]

I have a form that is composed of text boxes that are in tabular form, and the form has data entry set to false. The form is based on a table (Master File). I am using the ACCESS supplied get first, get next...etc that are on the bottom of the form, like so

.

My problem is that I make development changes to the Master, but I can't seem to be able to change the order in which the records are displayed, one at a time, on the form. I have sorted the Master by date, oldest to newest, but it doesn't change the display order. Is there any way to change that, and would best practices be to add buttons to get first...etc?

 

[pbaldy]

The form has an Order By property, or can be based on a query with sorting applied.

 

[jpl458]

The form has an Order By property, or can be based on a query with sorting applied.

The order by property works well indeed.

Thanks

 

[pbaldy]

They were conflicting with each other.

What were conflicting with each other?

 

[pbaldy]

The order by in the query was being overridden by the order by in the form.

What query? "The form is based on a table"

 

[jpl458]

They were conflicting with each other. Try to stick with using only one method or you'll make your head spin. Personally, I like using the query to order the recordset.

By using a query are you saying that you do a Make Table to get things in the proper order?

 

[jpl458]

I OK with SQL, I didn't think about the record source. Doing it the way you describe leaves the file intact with less chance for error.

Thanks Pat