Hi everyone,
I have looked and looked and can't find the answer to this issue so I am posting here hoping for some help.
I have developed a comprehensive Stock and Inventory system using Access 2007.
Here is the issue I have.
I have a main form called "BulkPartsMainForm"
It has a number of tabs that contain subforms.
One of the tabs is called "Alter Web Prices/SOH". The subform "loaded" into this tab is called "AlterWebSubForm".
This form enables the user to edit various bits of data for each product. It all works well. I have added some VBA code that logs any changes to a field for Audit purposes. It also logs the name of the form.
This works well when the "AlterWebSubForm" is opened by itself (as a Main Form) and not defined as a subform.
Using Screen.ActiveForm, it correctly extracts the name, "AlterWebSubForm".
When "AlterWebSubForm" is defined as a subform, the Screen.ActiveForm extracts the name of the MainForm, in this case "BulkPartsMainForm"
How can I get the name of the actual subform?
Thanks for any help you can provide.
Regards
Greg
I have looked and looked and can't find the answer to this issue so I am posting here hoping for some help.
I have developed a comprehensive Stock and Inventory system using Access 2007.
Here is the issue I have.
I have a main form called "BulkPartsMainForm"
It has a number of tabs that contain subforms.
One of the tabs is called "Alter Web Prices/SOH". The subform "loaded" into this tab is called "AlterWebSubForm".
This form enables the user to edit various bits of data for each product. It all works well. I have added some VBA code that logs any changes to a field for Audit purposes. It also logs the name of the form.
This works well when the "AlterWebSubForm" is opened by itself (as a Main Form) and not defined as a subform.
Using Screen.ActiveForm, it correctly extracts the name, "AlterWebSubForm".
When "AlterWebSubForm" is defined as a subform, the Screen.ActiveForm extracts the name of the MainForm, in this case "BulkPartsMainForm"
How can I get the name of the actual subform?
Thanks for any help you can provide.
Regards
Greg