Unanswered: Using WHERE clause in DLookup function
Can someone please help me with completing this function? I am so close to getting this database but still keep having little problems, especially with Visual Basic!
I currently have this line on one of my forms:
If (Nz(DLookup("URN", "tblSrvRspns", "URN = " & Me!cboURN), 0) = 0) Then
However I need for this lookup to include WHERE SrvID = Me!cboSrvID.
SrvID is also in the tblSrvRspns table. The query will hopefully then translate as when there are zero entries of URN (as specified in Me!cboURN) in tblSrvRspns When SrvID, also in tblSrvRspns, equals Me!cboSrvID.
If someone can please help me with this I will be extremely grateful!!!