I am about as frustrated as can be.
This is straight from the MS support website:
The next example uses a variable, intSearch, to get the value.
How the hell is that different from my code like this:
This is straight from the MS support website:
The next example uses a variable, intSearch, to get the value.
Code:
Dim intSearch As Integer
Dim varX As Variant
intSearch = 1
varX = DLookup("[CompanyName]", "Shippers", _
"[ShipperID] = " & intSearch)
How the hell is that different from my code like this:
Code:
Dim quoteInput As Variant, quoteno As Variant
quoteInput = InputBox("Enter quote number for new order:", "New Order From Quote")
quoteno = DLookup("QuoteNumber", "tblQuotes", "QuoteNumber = " & quoteInput)
If quoteno <> quoteInput Then
MsgBox quoteInput & " is not a valid quote number"
Exit Function
End If