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.
Data type mismatch
Novice
Windows 10 
Access 2016
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.
Access Developer
Windows 10 Access 2016
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
Novice
Windows 10 Access 2016
Originally Posted by Bob Fitz
Many thanks,
Data Type Mismatch
Posting Permissions
Reply With Quote