Combo Box Type Mismatch

  • Thread starter Thread starter GitarJake
  • Start date Start date
G

GitarJake

Hello all,

I keep getting a Runtime error 13 "type mismatch error" when I try to select
records with my combo box. Here is the sql statement:

SELECT DISTINCTROW Contacts.UNIQUE_ID, Contacts.Company
FROM Contacts INNER JOIN Sales ON Contacts.UNIQUE_ID = Sales.Contact
WHERE (((Contacts.IDStatus) Like "*customer*"))
ORDER BY Contacts.Company;

When I try to create a new combo box, the wizard gives me this error:

Syntax error in query expression '[SELECT DISTINCTROW
[Contacts]].[Unique_ID]'.

Can someone tell me my flaw here?


Tia!
 
First off, are you using the join to filter the Contacts table? I don't
see the Sales table being used at all.
The only thing I can suspect is that IDStatus is a numeric field,
containing an ID so it can not be compared with a string.
I suggest taking this SQL into the query builder and checking it there.

Good luck,
Pavel
 
Hi Pavel,
First off, are you using the join to filter the Contacts table? I don't
see the Sales table being used at all.
Click to expand...

No not a filter, just left over.

The combo box was working well when it had it's own record source. When I
borrowed the sql from a query that had alternate tables I wanted to use, the
posted errors occured.

The combo and the forms record sources are the same.

After cleaning it up, the error still exists.
The only thing I can suspect is that IDStatus is a numeric field,
containing an ID so it can not be compared with a string.
I suggest taking this SQL into the query builder and checking it there.
Click to expand...

One curious tidbit is that UNIQUE_ID is text field. Could it be that
combo boxes require a numeric field?
Good luck,
Pavel
Click to expand...

Thank you Pavel, I think I will need all the good luck I can get!

Jake
GitarJake said:
Hello all,

I keep getting a Runtime error 13 "type mismatch error" when I try to select
records with my combo box. Here is the sql statement:

SELECT DISTINCTROW Contacts.UNIQUE_ID, Contacts.Company
FROM Contacts INNER JOIN Sales ON Contacts.UNIQUE_ID = Sales.Contact
WHERE (((Contacts.IDStatus) Like "*customer*"))
ORDER BY Contacts.Company;

When I try to create a new combo box, the wizard gives me this error:

Syntax error in query expression '[SELECT DISTINCTROW
[Contacts]].[Unique_ID]'.

Can someone tell me my flaw here?

Tia!
Click to expand...
Click to expand...
 
I don't think the combo box cares whether the field is text or numeric.
However, if it is bound to a numeric field in the table and has a text
field in the row source, it might be a problem. Check the bindin
carefully and make sure the row source query returns the right fields.
Pavel
Hi Pavel,
First off, are you using the join to filter the Contacts table? I don't
see the Sales table being used at all.
Click to expand...

No not a filter, just left over.

The combo box was working well when it had it's own record source. When I
borrowed the sql from a query that had alternate tables I wanted to use, the
posted errors occured.

The combo and the forms record sources are the same.

After cleaning it up, the error still exists.
The only thing I can suspect is that IDStatus is a numeric field,
containing an ID so it can not be compared with a string.
I suggest taking this SQL into the query builder and checking it there.
Click to expand...

One curious tidbit is that UNIQUE_ID is text field. Could it be that
combo boxes require a numeric field?
Good luck,
Pavel
Click to expand...

Thank you Pavel, I think I will need all the good luck I can get!

Jake
GitarJake said:
Hello all,

I keep getting a Runtime error 13 "type mismatch error" when I try to select
records with my combo box. Here is the sql statement:

SELECT DISTINCTROW Contacts.UNIQUE_ID, Contacts.Company
FROM Contacts INNER JOIN Sales ON Contacts.UNIQUE_ID = Sales.Contact
WHERE (((Contacts.IDStatus) Like "*customer*"))
ORDER BY Contacts.Company;

When I try to create a new combo box, the wizard gives me this error:

Syntax error in query expression '[SELECT DISTINCTROW
[Contacts]].[Unique_ID]'.

Can someone tell me my flaw here?

Tia!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top