I have not used Access since 2003, and I didn't use it very much. A friend asked me to fix a problem in an Access 2010 database. He created a series of tabs with subforms on each tab. The first tab contains the main profile of a customer. The other tabs contain detail information about customer orders, services, etc. Each subform has its own table and all of the tables have a Customer ID field. The problem is, he wants to select a customer on the primary customer profile tab and when he clicks another tab he wants it to display the data on the tab for the same customer as was selected on the primary customer profile. If the customer ID id 345 on the profile and he clicks the Orders tab, he wants to see the orders for customer 345. I created queries to select the customer ID fro each subform on the tabs and intend to use the Customer ID field on the profile to select the correct customer., but I do not know the names of the forms and subforms and he does not remember. I intend to use the subform names to create the criteria reference in the query. How can I find the names of the forms and subforms using something like properties.
Last edited: