The database that applies the following code has had a recent change:
strSQL = "SELECT * FROM [KT VANPOOL DRIVER RECORDS] WHERE [ACTION] = " & Forms![KITSAP TRANSIT DRIVERS].[ACTION]
The change was formatting the [ACTION] field from an number to a text format. Doing so would allow an alphanumeric input in this field on a Form.
This change has resulted in the following error:
"Run-time error '3464': Data type mismatch in criteria expression."
Any help to resolve this problem is much appreciated!!
Tommy