Access at it's Finest(2)

  • Thread starter Thread starter Ryan Clair
  • Start date Start date
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.
 
Is the combo box Column Count set to 4? The width can be 0, but I think it
still needs to be there.
 
You must log in or register to reply here.

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

Similar Threads

Combo Box On Click 6
Newbee needs help Combo Box access 2007 1
Need combo box to refresh when moving to new record 2017 1
Error with combobox.column(1) in DoCmd.runSQL 5
on click result 8
Hlp! Requery Cbo Not Working 3
Old and new values of combo box columns. 3
How to get the value of non-bound combo box column? 5

Back
Top