Hello! im stumbled on this...and i think its a lack of Access fundamental training....i've made the explanation as simple as possible.
I have a "Table1" that list "Name" & "Job_Number". I have a form that does a Dlookup against the "Job_Number" and list on another text cell the "Name" associated via that Table1. This is no big deal.
However, I then want the form to also display in another Textbox all the email's that are associated with that "Name" the dlookup solved for. So for instance, if the Dlookup solved that manually entered Job_Number: 11001 was Bob's job, then it displays BOB Y is populated in the txtPM text box. Then I want Bob Y's email, his boss's and the sales guy's emails to populate in the field (bob@live.com;boss@live.com;sales@live.com). I originally had that setup in another "TABLE2" like the below for ANOTHER dlookup, but for some reason, i cannot DLookup while usnig the Name's dlookup's value...I dont care if its on a query, form, or table...i just need it to list all the emails so that I can VBA it back into the Auto Emailer I set up. So right now, it displays BOB like it should, but the email text box, "#Error"
thanks!!!!
Table 1:
JOB_Numbers____ Name
11001 _________ _ Bob Y
11002 _________ _ Dob D
11003 _________ _ Cob S
Table 2:
Name2 Email2
Bob _____ bob@live.com;boss@live.com;sales@live.com
Dob_____ dob@live.com;boss2@live.com;sales2@live.com
Cob _____ cob@live.com;boss3@live.com;sales3@live.com
Project Number: Manual Entry "txtjobnumber"
Project Manager: Dlookup below "txtPM"
Working Code
1.) gets the Name from the manually entered Job:
=DLookUp("Name","Table1","Job_number=" & [txtjobnumber])
2.) Does not work =DLookUp("Email2","Table2","Name2=" & [txtPM])