Okay, it appears I am still messed up. The field named ProjectCode pulls
from tblMeetings2001 in a combo box with the MeetingID hidden from the
dropdown. I placed the ProjectCodeID field, from tblAttendeeInformation, on
the form to refer to when needed. So this was the code I used, following
your example and it is still only grabbing the first record in
tblMeetings2001's dates, no matter which project code I select.

DLookUp("[Start Date]","tblMeetings2001","MeetingID = " & [Forms]!
[frmAttendeeInformation]![ProjectCodeID])

What am I missing here? It's got to be something obvious. Thanks again!


Douglas J. Steele wrote:
Yes.

Is the ProjectCodeID of interest available through a control on the form?

DLookup("[Start Date]", "tblMeetings2001", "ProjectCodeID = " &
Forms!NameOfForm!NameOfControl)

or, if ProjectCodeID is text,

DLookup("[Start Date]", "tblMeetings2001", "ProjectCodeID = '" &
Forms!NameOfForm!NameOfControl & "'")

No there are many rows of data in TblMeetings2001, so I need to match it
with
[quoted text clipped - 18 lines]

Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200907/1