Data type mismatch

[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

 

[Joseph Meehan]

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

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.

 

[Guest]

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