Control Source on a Text Box

[Guest]

Hi, I have two combo boxes that each have the options of yes/no/unsure. I
want my textbox to display "Yes" where both the combos values = yes. if not
then to display "no".

HELP! Please...

 

[Pieter Wijnen]

in the afterupdate event of both cbo's place

Sub cbo1_AfterUpdate
If Me.cbo1.value = "yes" and me.cbo2="yes" then
me.txtbox.value = "yes"
else
me.txtbox.value="no"
end if
End Sub

 

[Pieter Wijnen]

in the afterupdate event of both cbo's place

Sub cbo1_AfterUpdate
If Me.cbo1.value = "yes" and me.cbo2="yes" then
me.txtbox.value = "yes"
else
me.txtbox.value="no"
end if
End Sub

Hi, I have two combo boxes that each have the options of yes/no/unsure. I
want my textbox to display "Yes" where both the combos values = yes. if
not
then to display "no".

HELP! Please...

--

 

[John Vinson]

Hi, I have two combo boxes that each have the options of yes/no/unsure. I
want my textbox to display "Yes" where both the combos values = yes. if not
then to display "no".

HELP! Please...

Me!textbox = Format(Me!combo1 = "Yes" AND Me!combo2 = "Yes", "Yes/No")

John W. Vinson[MVP]

 

[Guest]

ok. i have re-written that to apply to my database. it's all working. how do
i get that value to save itself in a field against a record?

 

[fredg]

ok. i have re-written that to apply to my database. it's all working. how do
i get that value to save itself in a field against a record?

Why would you want to?
You don't.

As long as you have saved the individual values, any time you need the
result, re-compute it as you already have.