Base a value on a option group choice

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set a value for and lock textboxes based on a option group choice.
The option group is functioning properly.
 
Kim said:
I want to set a value for and lock textboxes based on a option group choice.
The option group is functioning properly.
Click to expand...


Use the option group's AfterUpdate event:

Select Case Me.optiongroup
Case 1,2,5 'options that hide other controls
Me.textbox1.Visible = False
. . .
Case Else 'otherwise, show other controls
Me.textbox1.Visible = True
. . .
End Select

If your form can navigate to other records, then you will
probably want the same code in the form's Current event.
 
Thanks so much Marsh - easy fix!
--
Kim


Marshall Barton said:
Use the option group's AfterUpdate event:

Select Case Me.optiongroup
Case 1,2,5 'options that hide other controls
Me.textbox1.Visible = False
. . .
Case Else 'otherwise, show other controls
Me.textbox1.Visible = True
. . .
End Select

If your form can navigate to other records, then you will
probably want the same code in the form's Current event.
Click to expand...
 

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

Option Group Value Pass to Query 2
Update textbox from option group 5
Access Create option group without using wizard? 2
Option Group question 3
How do you apply a default value to an Option Group? 3
Option Group - Clear Yes/No 8
Option Group question 2
Option Group Auto Open 5

Back
Top