DLookup dilemma

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

Greetings to those who read this. My apologies but I need
to come back in with an issue I've posted before because I
am having a difficult time getting the DLookup to work.

I have 2 tables (more fields then listed).
tblTeamMembers is a list of company employees
Name
Email
usrtblPRAProjectTeamMembers is were the data is stored
ClientCode
ProjectTeamMember (drop list from TableA)
ProjectTeamMemberEmail (textbox)

I have a continuous form (usrfrmPRAProjectTeamMembers) in
which employees are selected for the different projects.
Rather than have the user type out all the info, I would
like to prefill some of the fields. I have been
struggling with the following line of code (between
astericks). I have gotten to where the email box will
fill but with only the first email listed on
tblTeamMembers. The 'ProjectTeamMember' selection makes
no difference as the same email shows for everyone.
***************
Me.ProjectTeamMemberEmail = DLookup
("", "tblTeamMembers", "[ProjectTeamMember]='" &
Forms![usrfrmPRAProjectTeamMembers]![ProjectTeamMember]
& "'")
***************
The first thing I would need to know is: Can a DLookup be
used on a continuous style form?

If yes, then what or where am I making the error?

Many thanks to those of you who view and respond to this
and especially if it gets to work properly.
** John
 
Stop the presses. No need for anyone to respond, I
finally got it to work correctly.
** John
 
Back
Top