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
