option groups 1

[integritycare]

Hello,

I would appreicate some help with option groups please.

I have two option groups that are independant of each other but on the same form.

What I want to do is from option groupt 1 make an option button locked in option group 2.

Many thanks,

Integrity

 

[dhookom]

How far did you get? Do you have any names of the option groups and the option buttons?

Which value in one makes which value in the other locked?

I am not sure about locking a single option but I expect you could disable an option with code like:

Private Sub Group1_AfterUpdate()
    Me.Option19.Enabled = Me.Group1 <> 2
End Sub

Duane
Hook'D on Access
MS Access MVP