Run-time error 13,really need help

[rry2k]

I'm struggling with trying to set a filter on a subform based on a combobox value on the parent form. I'm trying to select records from a table
where field = combo15.column(1). The code or queries I use never like the syntax I use for column(1) so I'm trying to load the value into a variable. The table value is long int and the variable is long but I keep getting a type mismatch.

I would really like to get this resolved before the holiday so if someone could help I would really appreciate it.

Thanks..Russ

 

[JustinEzequiel]

if i understand you correctly, you are trying to assign the value of 'combo15.column(1)' to a variable declared as long (ex. 'dim nVal as long')

if i misunderstood you, please ignore the rest.

the only time i got run-time error 13 (type mismatch) was when i tried to assign a non-numeric value to my long variable.
ex.

nVal=combo15.column(1) ' where combo15.column(1)="abc"

have you checkd if 'isnumeric(combo15.column(1))' ?