Feb 17, 2006 #1 Brogrim Technical User Jul 28, 2000 184 IE I am trying the following but can't ghet the syntax correct. DLookup ("[MemPOMID]", "tblMemPOM", "[MemberID] =([Forms]![frmROCSwitchboard]![lstMember]) Any help appreciated
I am trying the following but can't ghet the syntax correct. DLookup ("[MemPOMID]", "tblMemPOM", "[MemberID] =([Forms]![frmROCSwitchboard]![lstMember]) Any help appreciated
Feb 17, 2006 1 #2 mp9 Programmer Sep 27, 2002 1,379 GB Try: Code: DLookup ("[MemPOMID]", "tblMemPOM", "[MemberID] =" &[Forms]![frmROCSwitchboard]![lstMember]) http://www22.brinkster.com/accessory/ Upvote 0 Downvote
Try: Code: DLookup ("[MemPOMID]", "tblMemPOM", "[MemberID] =" &[Forms]![frmROCSwitchboard]![lstMember]) http://www22.brinkster.com/accessory/
Feb 17, 2006 Thread starter #3 Brogrim Technical User Jul 28, 2000 184 IE Absolutely brillant, thanks Upvote 0 Downvote