This is straight from the MS VBA support website - What the hell is different in my code above!Ok Guys, I guess I still don't get it. What the hell is wrong with this code!
Quote number is a field in the tblQuotes
I've tried it with brackets around fields as well, I just am not letting the proper syntax into my brain I guess.
Microsoft website is exactly like my code.
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
Frustrated!!!