DLookUp Issue
in [Forms]
|
From: floyd33 via AccessMonster.com on 6 Nov 2009 09:23 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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1
From: Mark Andrews on 6 Nov 2009 09:42 Try =Dlookup("Phone","tblAttendee","(AttendeeType2 = 48) AND (MeetingID = " & CStr(Me.MeetingID) & ")") HTH, Mark "floyd33 via AccessMonster.com" <u17874(a)uwe> wrote in message news:9eb66e24ae3dc(a)uwe... >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. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1 >
From: floyd33 via AccessMonster.com on 6 Nov 2009 11:31 I get the dreaded "#Name?" displayed. Mark Andrews wrote: >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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1
From: Mark Andrews on 6 Nov 2009 15:10 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 "floyd33 via AccessMonster.com" <u17874(a)uwe> wrote in message news:9eb78dbfa3e9d(a)uwe... >I get the dreaded "#Name?" displayed. > > Mark Andrews wrote: >>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. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1 >
From: floyd33 via AccessMonster.com on 9 Nov 2009 07:45 Yes to all of this. Mark Andrews wrote: >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] >>>> >>>> I can't figure this one out. Any help is appreciated. -- Message posted via http://www.accessmonster.com
|
Pages: 1 Prev: Cumulative Sum Query Next: Tabbing creates new record, which I don't want |