Help. I want to view a specific record when I click on its ticket Number. Example I choose to ticket 00003. I got this error Data Type mismatch. I used condition ="[ID]=" & [ID]. They are short text.
Try: ="[ID]='" & [ID] & "'"
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks. Bob Fitzpatrick
Originally Posted by Bob Fitz Try: ="[ID]='" & [ID] & "'" Many thanks,
Forum Rules