Read only record

[sdawson]

What's the easist way to set a record in a form to read-only if a check box is ticked? When going from one record to the next, the user needs to facility to change a record only if the tick box is empty.

Ta

 

[KenHigg]

How many flds are on the form? You may be able use the onCurrent event to set the text boxes enabled property off or on...

 

[sdawson]

Way too many

 

[KenHigg]

Hum... The best way I can think of at the moment is to loop through them and set them off / on looking at custom tag property...

 

[sdawson]

Yep. Me too. Seemed a bit long winded so I thought I'd ask.

Thanks

 

[ghudson]

If the forms OnCurrent event you can simply use something like this to prevent changes to the current record if the check box is set to Yes/True...

If CheckBox = -1 Then

    'Me.AllowAdditions = False
    'Me.AllowDeletions = False
    Me.AllowEdits = False

Else

    Me.AllowEdits = True
    
End If

 

[sdawson]

Thanks GH.

Works good.