RUNTIME ERROR 13

[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

 

[gusbrunston]

Hi.

This is probably something you know and have tried...

in VBA code the count of columns in a combo box starts at zero:

me.txtbox = combobox.Column(0)

(if you want the first column in the form view). Gus Brunston An old PICKer, using Access2000
gustrel@aol.com

 

[rry2k]

I'm onto the offset starting with 0 but thanks anyway.

Russ