Sorry to ask a new question so soon, but I really need to figure this out. . .
Say I have a combo box (companyname) on a form. Then Say I have another combo box (employeename) that autofills when a particular company name is selected since there's more than one employee name for each company name. Is there a way to produce a temporary table with the company name that is selected (would stay the same), and all of the employee names for that company?
REASON: I created a macro that sends a table to the company name (via e-mail) when the form is updated, but it sends the whole table with all of the companies included in the table. I need to find a way to send a table to the company with just the specified company name and employee names for the company that was updated on the form.
I'd greatly appreciate any help,
Thanks,
Nick
Say I have a combo box (companyname) on a form. Then Say I have another combo box (employeename) that autofills when a particular company name is selected since there's more than one employee name for each company name. Is there a way to produce a temporary table with the company name that is selected (would stay the same), and all of the employee names for that company?
REASON: I created a macro that sends a table to the company name (via e-mail) when the form is updated, but it sends the whole table with all of the companies included in the table. I need to find a way to send a table to the company with just the specified company name and employee names for the company that was updated on the form.
I'd greatly appreciate any help,
Thanks,
Nick