Hmmm.. I am obviously missing something important lol. But I'm not sure what.
I now have the following code
Private Sub EditQuoteBtn_Click()
If IsNull(DLookup("QuoteNumber", "JobDetails", "QuoteNumber=" & Me.QuoteSearchTxt)) Then
MsgBox MESSAGETEXT, vbExclamation, "Quote Number Does Not...