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

Help linking two tables

P: 1
I'm sure there is an easy way to do this but I haven't found it yet. I have one form where all the information is entered in with a combo box with the sales reps name (looked up from a seperate table with all the names and email address of the sales reps in it) however I need a way to make sure that I can use the reps email address somehow. I've tried so many ways already, I'm pretty much an Access newbie so any help would be great.

Thanks,
N
Jan 4 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I'm sure there is an easy way to do this but I haven't found it yet. I have one form where all the information is entered in with a combo box with the sales reps name (looked up from a seperate table with all the names and email address of the sales reps in it) however I need a way to make sure that I can use the reps email address somehow. I've tried so many ways already, I'm pretty much an Access newbie so any help would be great.

Thanks,
N
You could create an unbound textbox and set the control source to something like this.

Expand|Select|Wrap|Line Numbers
  1. =DLookup("[email]","TableName","[RepID]=" & [ComboboxName]
Jan 6 '07 #2

NeoPa
Expert Mod 15k+
P: 31,186
A more complicated but more efficient way would be to get both fields in the ComboBox.
The name would show but the e-mail address would be included and could be copied to another (TextBox) control in the AfterUpdate event of the ComboBox.
As Nico would say :
Idea?
Jan 7 '07 #3

Post your reply

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