By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,658 Members | 1,908 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,658 IT Pros & Developers. It's quick & easy.

How to reference a field in a parent table in a SendEmail macro. Access 2010

P: 37
I have 2 tables (amongst others). The parent table is called tbl_JobReferences and the other is called tbl_Colours.

The database is used to store the quantity of printing plates in stock. When a printing plate stock reaches zero, a data macro triggers and sends an email to
re-order the plate.

The problem is, the plate's reference number (YR Number)is in the parent table (tbl_JobReferences), as all the plates in a family has the same number, but I cannot reference this table within the body of my email. I keep getting the error

"The identifier '[tbl_JobReferences].[YR Number]' could not be found."

Is there anyway to get this related field into the body of my email?
Jun 24 '12 #1
Share this Question
Share on Google+
2 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,282
Please list the fields in your two tables and how they are related. There should be a many-one relationship between them so that the tables are properly related. This is where you must start.
Jul 25 '12 #2

P: 37
Sorted. I set up a macro on a form instead of the table. This allowed me to add the YR Number to a sendEmailObject. Thanks.
Jul 25 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.