Data type mismatch

  • Thread starter Thread starter Khalil
  • Start date Start date
K

Khalil

Hi,
I have a form bassed on a table.
I added an unbound control (combo box) in the header of the form in order to
use it to select certain records.
Instead of the employee neames in the combo box I see their employeeID
number and when choosing one of them I have the error number 3464: "Data
type mismatch in criteria expression"

I couldn't know wher i went wrong.
Can anyone help please.
Khalil
 
Khalil said:
Hi,
I have a form bassed on a table.
I added an unbound control (combo box) in the header of the form in
order to use it to select certain records.
Instead of the employee neames in the combo box I see their employeeID
number and when choosing one of them I have the error number 3464:
"Data type mismatch in criteria expression"

I couldn't know wher i went wrong.
Can anyone help please.
Khalil
Click to expand...

Most likely the box and the table have different data types. One is
likely a number and the other is likely text. Check the properties of the
control and the table field.
 
Hi Khalil,

Try the following sample:

Combo box to find a record
http://www.access.qbuilt.com/html/find_a_record.html


Tom
_________________________________________

:

Hi,
I have a form bassed on a table.
I added an unbound control (combo box) in the header of the form in order to
use it to select certain records.
Instead of the employee neames in the combo box I see their employeeID
number and when choosing one of them I have the error number 3464: "Data
type mismatch in criteria expression"

I couldn't know wher i went wrong.
Can anyone help please.
Khalil
 
Back
Top