Run-time error 2447 when referring to combo box

G

Guest

I am getting a run-time error 2447 message (There is a invalid use of the .
(dot) or ! operator or an invalid parenthesis) in my code when I refer to the
value in a combo box. This error started showing up when I changed the number
of columns from 2 to 1 and eliminated the numeric value that were in column 0
of each record.

The combo box is named cbo_Search_Where, is a value list containing row
source values of: "BSE";"ASSET". The Column Count is 1, and the Bound Column
is also 1.

I have several references to the value of this combo box in my code, and in
each case it is raising this error, and highlighting the line of code where I
reference Me.cbo_Search_Where. What is wierd is that if I elect to debug
when the error is raised, I can refer to other properties of the cbo in the
immediate window and not have it error out, but when I refer to the combo
boxes Value property, it throws the same error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top