I have a table called _users
it has a field called Job Type
In my table called Service Request, i have a field called Assigned Employee.
I want to do a search in the table _users for all Job Type = Worker and that will be in my dropdown.
That works.
But after posting the form, this is the error i have on the list screen
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/asprunnerpro/_Service_Request_list.asp, line 1625
this is the error i have on the view screen:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/asprunnerpro/_Service_Request_view.asp, line 298
any ideas?