[MS_AccessPros] DLookup vs Create recordset and get recordcount

 

Hi all,

On one of my forms I display a label if there is a related record in another table. Is it best to use DLookup vs create recordset and get recordcount? Here is what I currently have and I would like to know what is best:

'Display label re relationships entered if applicable
If Not IsNull(DLookup("ContactID1", "ContactsLink", "ContactID1 = " & Me.ContactID & " Or ContactID2 = " & Me.ContactID)) Then
Me.lblRelEnt.Visible = True
Else: Me.lblRelEnt.Visible = False
End If

thanks!
Connie

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___