cascading combo box error message

b9791

Brian
Local time
Today, 08:13
Joined
Jul 30, 2002
Messages
29
I have used the attached database to code my cascading combo boxes, but when I try to select a value from the first combo box, i get the error message "Data Type Mismatch.:confused: " Why would I get this mesage?

My first combo box is selecting categories and my second is selecting subcategories that are related to the first.

The tables are as follows:
tblCategories
*CatNum (PK)
*CatName

tblSubCategories
*SubCatNum (PK)
*SubCatName
*CatNum

Any help would be greatly appreciated. ;)
 

Attachments

b9791,

I downloaded the sample, converted it to A2000, ran it, and
encountered no errors. Worked OK.

Wayne
 
Let me clarify. The attachment worked fine for me in the their database. When I used the code in my own database, it no longer worked.
 
b9791,

The only way that you would get that error is if the key
field in your database had a text value in it. That would be
the type mismatch. It is not a coding problem, it is a data
problem.

Wayne
 

Users who are viewing this thread

Back
Top Bottom