Access at it's Finest(2)

R

Ryan Clair

Combo box and using the .column() command, annoying. I've seen a number
of posts on here that ask about this but not a definite answer. I have
1 combo box and 1 text box. On the After Update event, I execute the
following command:

textbox = combobox.column(3)

There IS a value in the fourth column in the query (0 based index) yet
it says "null" when I'm in debug mode and hover over it. And no I don't
have any other event firing away at the time it runs, only After
Update.

Has anyone found a way around this annoying problem? I can't use
column(0) or (1) for they are being used as references (which they too
don't work if they are moved to the (2)'nd place.)

As always, thanks in advance.
 
B

BruceM

Is the combo box Column Count set to 4? The width can be 0, but I think it
still needs to be there.
 
Top