Hi,
I'm getting the error when I run this code
The code has to look up whether the DHL_from value is 1 or nothing. The error is on the Country_ID field.
I'm getting the error when I run this code
Code:
Private Sub cmbSelectVan_AfterUpdate()
Dim DHLDepAllowed As Variant
Dim FedExDepAllowed As Variant
DHLDepAllowed = DLookup("DHL_from", "Zones_World", "Country_ID = '" & cmbSelectVan & "'")
If (DHLDepAllowed < 1) Then
MsgBox "blabla"
cmdSelectVan.SetFocus
Exit Sub
End If
The code has to look up whether the DHL_from value is 1 or nothing. The error is on the Country_ID field.