Hello all,
Attached is a test version of my database. I'm trying to create a form which can search through my one table dynamically. Everything works great except for when I try to search by the Tech ID. I get a data type mismatch error.
The form which I'm testing is the Test Form. The code I'm using I got from the microsoft site here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210242
I'm pretty sure it's something simple I've overlooked.
Attached is a test version of my database. I'm trying to create a form which can search through my one table dynamically. Everything works great except for when I try to search by the Tech ID. I get a data type mismatch error.
The form which I'm testing is the Test Form. The code I'm using I got from the microsoft site here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210242
I'm pretty sure it's something simple I've overlooked.