sellect one item so that the other options are frozen.

[justagrunt]

Hi,
On a price list form, I have a number of selections, they are tick boxes. If I choose one I would like the others in the list to become inactive, and because I chose this one other selctions on the page are now able to be picked and others not.How does one in code, say that if i choose this one the others are now frozen or inactive.
Kind Regards
Bill

 

[TerpFan2001]

Bill:

Here is an example using two check boxes named chk1 and chk2. When the user updates chk1 the code will either enable or disable chk2 depending on whether the value for chk1 is true or false. Hope this helps.

Private Sub chk1_AfterUpdate()

If Me.chk1 = vbTrue Then

Me.chk2.Enabled = False

Else

Me.chk2.Enabled = True

End If

End Sub

 

[justagrunt]

Thanks

 

[KenReay]

Hi

Isn't this what an option group does automatically?

Try putting a frame on your form using the wizard Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK