Enabling a Text Box based on the Content of another Text Box

[yus786]

Hello again

I need something like this.

If the content of TextBox1 is "Yes", then i need the user to be able to view TextBox2.

If the content of TextBox1 is "No", then i need the TextBox2 to be greyed out.

Is this easily done?

 

[khawar]

if [textbox1]="Yes" then
[textbox2].enabled=true
else
[textbox2].enabled=false
end if

 

[yus786]

if [textbox1]="Yes" then
[textbox2].enabled=true
else
[textbox2].enabled=false
end if

Thanks

Where do i put these codes? (I'm a bit of a novice)

Cheers

 

[khawar]

After update event of texbox1

 

[yus786]

After update event of texbox1

But i'm not actually entering anything into this textbox.

This is a subform that's coming through from somewhere else - ie the data is already populated.

I tried the 'after update' and it didn't work - nothing happening, presumably as the textbox is not getting touched?

Advice?

 

[yus786]

Hi - i'm still struggling with this?

Anyone please help me??

 

[georgedwilkinson]

I'm not sure what you're saying is going on. You should look at the available events and see which one is most appropriate to your situation.

If I understand you correctly, you may want to use Khawar's code in the "On Current" event. Also, you may try looking at textbox1's "On Change" event. If not, there are dozens of others that may be right...in fact, you may need it in several places, depending on your circumstances.

In my case, when I don't know which is appropriate, I just code all the events with a MsgBox, run my scenarios, and put the code in where the most appropriate MsgBoxs show.

 

[Zaeed]

you could put it in the forms load code

 

[khawar]

Use form on Current event

 

[yus786]

Use form on Current event

brilliant this worked.
Thanks for your help everyone.