Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I disable some field in Form?

Status
Not open for further replies.

acin0026

Technical User
Feb 5, 2001
12
TH
I have a Form which you can choose USA. or International. Then customer will choose state or some countries. (That form shows all states and some countries). I would like to disable other countries (gray options) if they select USA. Also, if they select Internaional, all states will show gray options.

Could you help me with this.

thanks.
 
Like this:
IF Me![NameOfSomeField] = SomeValue Then
Me![NameOfAnother].Enabled = False
Else
Me![NameOfAnother].Enabled = True
End if

Make sure that the field(s) you are about to disable do not have the focus or an error will occur. That's it! Gord
ghubbell@total.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top