Make second combo column trigger event

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Hi Groupies

I have a combo box that show a job number and then yes or no. If the value
of the second column is yes, I want a label to be visible on my form, if it
is no the label needs to hide.

I have tried many versions of:
If me.combobox.[column](2).value="yes" ...... and I can get nothing to
work.

I have been able to capture the value of the second column in a textbox with
a calculation but I can't even make that trigger anything for me.

Your help, as always, is greatly appreciated.
 
Did you remember that columns start counting with 0 (zero)?
Also try using True without any quotes instead of Yes.
 
Sorry for the major delay in replying.

Yep, I remembered the zero count and I have tried True, but alas, no
trigger.

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!

KARL DEWEY said:
Did you remember that columns start counting with 0 (zero)?
Also try using True without any quotes instead of Yes.
--
KARL DEWEY
Build a little - Test a little


CJ said:
Hi Groupies

I have a combo box that show a job number and then yes or no. If the
value
of the second column is yes, I want a label to be visible on my form, if
it
is no the label needs to hide.

I have tried many versions of:
If me.combobox.[column](2).value="yes" ...... and I can get nothing to
work.

I have been able to capture the value of the second column in a textbox
with
a calculation but I can't even make that trigger anything for me.

Your help, as always, is greatly appreciated.
Click to expand...
Click to expand...
 
Back
Top