Hello Guys,
Bit of a newbie so apologies in advance I wish to match 3 results if all 3 are true pop up a single message box appears, using the Dlookup method.
Obviously using this method I get 3 individual pop-ups if all criteria are met. but the goal is to get 1 popup if all 3 are met. please help
Bit of a newbie so apologies in advance I wish to match 3 results if all 3 are true pop up a single message box appears, using the Dlookup method.
Code:
'If DLookup("Retailer", "OnSite_CoverTrue", "Retailer='" & Me!PURCHASED_FROM & "'") = Me!PURCHASED_FROM Then
' MsgBox "ONsite Retailer = True"
' End If
'If DLookup("Brand", "OnSite_CoverTrue", "Brand='" & Me!TV_BRAND & "'") = Me!TV_BRAND Then
'
' MsgBox "ONsite Brand = True"
' End If
'If DLookup("Model", "OnSite_CoverTrue", "Model='" & Me!TV_MODEL & "'") = Me!TV_MODEL Then
'
' MsgBox "ONsite Model = True"
Obviously using this method I get 3 individual pop-ups if all criteria are met. but the goal is to get 1 popup if all 3 are met. please help