specifying order which form
RH

Forum home » Delegate support and help forum » Microsoft Access Training and help » Specifying the order in which form view displays records

Specifying the order in which form view displays records

resolvedResolved · Medium Priority · Version 2007

Paul has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course

Specifying the order in which form view displays records

How can I specify the order in which records are displayed in a form (e.g. to follow the auto number of rthe records, or to display alphabetically by organisation)?

RE: Specifying the order in which form view displays records

Hello Paul,

Hope you enjoyed your Microsoft Access courses with Best STL.

Thank you for your question regarding specifying the order in which a form view displays records.

This is entirely up to you. You can open any form in design view and completely rearrange the fields as you want. After you do this you should also use the Tab Order to set the way the tabs are active when pressing the tab key.

The Tab Order button can be found in the Control Layout group which is located in the Arrange ribbon.



I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

RE: Specifying the order in which form view displays records

Hi Rodney,

Sorry, I clearly didnt make the query clerar enough. I understand how to reorder fields on a form. What I do not understanhd is how to chnage the order in which records appear when in form view, when scrolling thorugh. For example, to change the order from the autonumber ID reference to the order of organisations alphabetically.

RE: Specifying the order in which form view displays records

Hello Paul,

To change the order the records are viewed you must sort by field. Click the field you require the sort to follow and click the sort ascending button (or descending if you want to go backwards through the data) then navigate through the records as normal. To put the sort back to the original order simply click in the autonumber ID field and sort in ascending order.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips


Server loaded in 0.06 secs.