473,395 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Assistance needed pulling correct field to email from Access Form

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
2 1294
JConsulting
603 Expert 512MB
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
>>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

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

Similar topics

3
by: middletree | last post by:
I have a page where I allow the user to select one or more names of employees to send an email to, which is sent automatically when the form is submitted. I have a field called EmailSentTo, and if...
2
by: Dalan | last post by:
I seemed to be having problems with structuring the use of NZ with a DSum expression. Having tried numerous variations of the expression without success, I'm asking for assistance. First some...
18
by: B Love | last post by:
I just need a small mod to my code (I think) to get the result I want. Earlier this week I had received help from FredG on concatenating a field in a form. I went on to create a field in the form...
4
by: Dalan | last post by:
I presume that using an open recordset method is the preferred method of accomplishing what I'm trying to do. Of course, if there are other options that would work, feel free to share them. I...
4
by: Wayne Aprato | last post by:
I have a simple database which was originally written in Access 97. When converted to Access 2000 file format it ran flawlessly in Access 2002. I've just tried to run it in Access 2003 and I am...
1
by: TerryD | last post by:
I have a form that has an unbound text field that I am using DLookup in to display the values from a Temp Table. My program calls for me pushing a button to print a report, which runs a query first...
1
by: aharding | last post by:
Hello! I am using Access 2003 I have been playing with DLookup all morning and have not been successful yet. I have never used this function...and have some limited experience with code. I...
23
by: JohnH | last post by:
I'm just recently come to work for an auto brokerage firm. My position involves performing mysterious rites, rituals and magick in order to get information out of their access database. This is...
7
by: Rnykster | last post by:
I know a little about Access and have made several single table databases. Been struggling for about a month to do a multiple table database with no success. Help! There are two tables. First...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.