A
amorrison2006
Hello
I have two tables,
1. Employees which links to Sales
The two tables have a [Name] field in common.
On the sales table I also have a check box.
I have a main form being the employees and sub-form being the sales.
There is also a combo box which lets me filter down.
What I wanted to do using the form is when I click on the check box on
the sales sub-form it will lookup the field in the employee
table and then send an email.
I hope someone can help with this as it's causing me lots of issues,
Thanks so much
Andrea
I have two tables,
1. Employees which links to Sales
The two tables have a [Name] field in common.
On the sales table I also have a check box.
I have a main form being the employees and sub-form being the sales.
There is also a combo box which lets me filter down.
What I wanted to do using the form is when I click on the check box on
the sales sub-form it will lookup the field in the employee
table and then send an email.
I hope someone can help with this as it's causing me lots of issues,
Thanks so much
Andrea