JoeBlack1980
asked on
2 Subform, how to sync ColumnWidth and ColumnOrder
Hi everybody,
In one of my access projects i have a FormA with some subforms.
Let's call Main Form as FormA
Let's call the subforms as FormASubform1 and FormASubform2.
FormASubform1 and FormASubform2 contains exactly same the same controls.
And the controls are like :
FormA!FormASubform1form.fo rm!Control 1
FormA!FormASubform1form.fo rm!Control 2
FormA!FormASubform1form.fo rm!Control 3
and goes on
and in the other
FormA!FormASubform2form.fo rm!Control 1
FormA!FormASubform2form.fo rm!Control 2
FormA!FormASubform2form.fo rm!Control 3
and goes on
So as you can see control names are also identical in each form
They are both in DATASHEET view.
What i want is , when a user change a columnwidth or columnorder or columnvisibilty in FormASubform1 i need FormASubform2 to has exactly the same view.
So it can be a press of a button , or oncurrent event (doesnt really matter) , a vba code which will alter the columns in FormASubform2 .
In one of my access projects i have a FormA with some subforms.
Let's call Main Form as FormA
Let's call the subforms as FormASubform1 and FormASubform2.
FormASubform1 and FormASubform2 contains exactly same the same controls.
And the controls are like :
FormA!FormASubform1form.fo
FormA!FormASubform1form.fo
FormA!FormASubform1form.fo
and goes on
and in the other
FormA!FormASubform2form.fo
FormA!FormASubform2form.fo
FormA!FormASubform2form.fo
and goes on
So as you can see control names are also identical in each form
They are both in DATASHEET view.
What i want is , when a user change a columnwidth or columnorder or columnvisibilty in FormASubform1 i need FormASubform2 to has exactly the same view.
So it can be a press of a button , or oncurrent event (doesnt really matter) , a vba code which will alter the columns in FormASubform2 .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...and thank you for an interesting and thought provoking Question...
;-)
Jeff
;-)
Jeff
ASKER
This is a fantastic solution,
Thanks