Combo Box ?

[TheViruz30]

I have the following in a combo box Yes, No followed by a text box called txt4

What i want to do is when user select yes from the combo box the text box will show P

If the user select no from the combo box the text box will show S





Any Ideas

 

[bonekrusher]

add. the following event procedure to the on click event of the combo box:

if me.combobox = yes then
me.txt4 = P
else
me.txt4 = ""
end if

 

[B4Geyer]

YesNoCombo.zip

Check out ansentry's YesNoCombo (attached) - it work really great

The man s a genius

 

[CEH]

First if you are using strickly a boolean...... Only "Yes" or "No" then do you really want a Combo? Now if you want to leave room to expand... by having the ability to add a third choice... for example.."Undecided" then I would use a combo. But for strickly a "Yes/No" then consider an option group. I attached a db to show you what I mean.

Also... "bonekrusher"....
if me.combobox = yes then
me.txt4 = P
else me.txt4 = ""
end if
This code would return nothing for "No"

 

[bonekrusher]

CEH...

I was trying to give him/her the basic code. P in this case could be either a variable or "p". If he/she wants no to return a value, he or she would have to add that in the else. It was only an example.