Option Group in Access 2000

P

Peter

There is a form of car for staff. The fields are Registration Number, Make,
Year.

It is required to create an option group to show whether the car is
available. I have attempted to use the option group wizard, should I assign
1 to Yes and 0 to No. How can I make the car not available ? For instance,
to make the 3 fields are not editable ?

Thanks
 
D

Douglas J. Steele

Strikes me that you need a boolean field (a "Yes/No" field), and use a check
box to indicate the status, not an option group.

In the form's Current event and in the check box's AfterUpdate event, put
code like:

Me.txtRegistrationNumber.Locked = Me.chkAvailable
Me.txtMake.Locked = Me.chkAvailable
Me.txtYear.Locked = Me.chkAvailable
 
Top