DLookUp Issue

[floyd33 via AccessMonster.com]

I am trying to use a DLookUp to display a value from a table to a form.

Field to display: Phone, tblAttendee, with criteria of AttendeeType2,
tblAttendee=48
Form to display it on:frmMeeting

I need the Phone field to pull from tblAttendee, where field AttendeeType2=48
and it matches up tblAttendee.MeetingID to tblMeeting.MeetingID.

I can't figure this one out. Any help is appreciated.

 

[Mark Andrews]

Try
=Dlookup("Phone","tblAttendee","(AttendeeType2 = 48) AND (MeetingID = " &
CStr(Me.MeetingID) & ")")

HTH,
Mark

 

[floyd33 via AccessMonster.com]

I get the dreaded "#Name?" displayed.

Try
=Dlookup("Phone","tblAttendee","(AttendeeType2 = 48) AND (MeetingID = " &
CStr(Me.MeetingID) & ")")

HTH,
Mark

I am trying to use a DLookUp to display a value from a table to a form.

[quoted text clipped - 7 lines]

I can't figure this one out. Any help is appreciated.

 

[Mark Andrews]

is the table named "tblAttendee"?
are there fields ("phone","attendeeType2" and "MeetingID") in table
"tblAttendee?
is there a control on your form with the name "MeetingID" that holds the
meetingid from table tblMeeting
that you want to use in the lookup?

Mark

I get the dreaded "#Name?" displayed.

Try
=Dlookup("Phone","tblAttendee","(AttendeeType2 = 48) AND (MeetingID = " &
CStr(Me.MeetingID) & ")")

HTH,
Mark

I am trying to use a DLookUp to display a value from a table to a form.

[quoted text clipped - 7 lines]

I can't figure this one out. Any help is appreciated.

 

[floyd33 via AccessMonster.com]

Yes to all of this.

is the table named "tblAttendee"?
are there fields ("phone","attendeeType2" and "MeetingID") in table
"tblAttendee?
is there a control on your form with the name "MeetingID" that holds the
meetingid from table tblMeeting
that you want to use in the lookup?

Mark

I get the dreaded "#Name?" displayed.

[quoted text clipped - 10 lines]