Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Tick Boxes - Not being able to lost focus until one or more complete

Tick Boxes - Not being able to lost focus until one or more complete

Tick Boxes - Not being able to lost focus until one or more complete

My name is Joanne and I have just started studying visual Basic 6. I would be very grateful to anyone that could help me to complete my database for my client in four days time. I have 8 tick boxes ("Yes/no" Data Types in the Table) on a form and I need to program the last tick box- To not proceed onto the next text box until one or more of the other tick boxes have been ticked. I have checked all my books to much avail. Can anyone give me some advise?

RE: Tick Boxes - Not being able to lost focus until one or more complete

Hi Joanne,
one thing you could do is set the text box's enabled property to false (found under the data tab of the properties). This would grey out the text box and not let anyone enter data into it.
You could then set the afterupdate event of each tick box to check and see if it has been ticked. If it has you can enable the text box. This would allow entry into the text box as soon as one of the boxes is ticked.
Alternatively you can just set the afterupdate event of the last tick box to check if any of them has been ticked then enable the text box.

The code for enabling the text box is:
Me.text1.enabled = true
replace the text1 with the name of the textbox on the form.
If you need any more help let me know,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close