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

Assistance needed pulling correct field to email from Access Form

P: 33
I have a database (created by someone else) that users complete a form to store provider data. One of the fields is location (LOCNUM) once the data is completed an email is created and sent out. The issue I'm having is LOCNUM is from a table called Location Table where a number (LOCNUM) is associated with a name (Location Name). How do I get the name on the email instead of the number?

Example -
User sees: Location: Anesth (combo box showing Location Name)
Email shows: 56 (LOCNUM)

I need email to show Anesth.
Jun 4 '07 #1
Share this Question
Share on Google+
2 Replies


JConsulting
Expert 100+
P: 603
I have a database (created by someone else) that users complete a form to store provider data. One of the fields is location (LOCNUM) once the data is completed an email is created and sent out. The issue I'm having is LOCNUM is from a table called Location Table where a number (LOCNUM) is associated with a name (Location Name). How do I get the name on the email instead of the number?

Example -
User sees: Location: Anesth (combo box showing Location Name)
Email shows: 56 (LOCNUM)

I need email to show Anesth.

>>once the data is completed an email is created and sent out.

whatever event triggers this create a lookup

myVal = dlookup("Location Name","Location","LocNum=" & me.LocNum)
Jun 4 '07 #2

P: 33
>>once the data is completed an email is created and sent out.

whatever event triggers this create a lookup

myVal = dlookup("Location Name","Location","LocNum=" & me.LocNum)
Thank you that worked.
Jun 6 '07 #3

Post your reply

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