Sorting using same criteria on two Tabs in access form

Hi there,
I have an access form, since I couldn't fit all the fields I had to do two tabs.Tab1 and Tab2.
Now user while using form, when they sort using a particular field common in both the tab would like to see both the tabs sorted in the same order.
Assuming tab1 and tab2 has Orderno, and user is on tab 1 and sorts on orderno when they go to tab2, they want it to already sorted on orderno so they ready continous data.
I will appreciate if somebody can let me know how I can apply the sort from one tab to another.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Are you saying that each tab contains a subform?
SivasanAuthor Commented:
no sub form, both tabs are forms themself. So I have a form  say A and there are 2 tabs on it. On clicking each tab, opens up a form B and C within the main form A.
So clicking tab1 would open form B and clicking tab2 would open form C.
So when they open B, if they sort by say a field OrderNo, when they open C which also has field orderno should be arranged in order of  sorting the user did form B
Jeffrey CoachmanMIS LiasonCommented:
<no sub form, both tabs are forms themself. So I have a form  say A and there are 2 tabs on it. On clicking each tab, opens up a form B and C within the main form A.>

Then AFAIC this is the very definition of a subform..  A subformis a form contained within another form..

Please post a sample of your db following these guidelines:

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Unhide any hidden database objects
10. Compile the code. (From the VBA code window, click: Debug-->Compile)
11. Run the compact/Repair utility.
12. Remove any Passwords and/or security.
13. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
14. Post the explicit steps to replicate the issue.
15. Test the database before posting.

In other words, a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.