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.
thx
SivasanAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS 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, ...post 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.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
Are you saying that each tab contains a subform?
0
 
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
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.