click option button - text1.text="" error

[DavidCdp1]

Hi

I have two option buttons, (hourly rate) and (daily rate). When I select hourly rate option then text1.enableed = true and text2.enabled = false. When I select Daily rate option then text1.text = "". But it is saying you can'g reference unless there is focus on it. How can I do it. Many thanks in advance for your help..
David.

 

[spacepro]

To set the focus you would use :

yourobjectname.setfocus

But it sounds like your second check box should be :

Me.Text1 = ""

You might want to do some research into naming conventions in access.
HTH
Andy

 

[DavidCdp1]

Thank You very Much Andy...You are a star..Thanks

 

[DavidCdp1]

Thanks for the information Pat..It is really helpful..

DavidCdp1