Get Focus

L

Luke

I would like to keep several fields in a form "greyed out"
until a user checks yes in another field (yes/no).
When yes is checked i would like these fields then to get
focus and become available for data input.

all help greatly appreciated
 
V

Van T. Dinh

Start the Form with other Controls disabled and use the CheckBox_AfterUpdate
Event to enable the other Controls.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
How do I clear a form? 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Mail Merge Directory Conditional Page Break 0
ASK Field Formatting 1
I have a document with 8 different templates on it. 1
Finding the proper style field and the numbered paragraph value within the style 0
VBA to extract data 0

Top