Checkbox to disable textboxes

[rob9740]

Hi all,
I was wondering could anybody help me out here. I've a checkbox that I want to use to disable two textboxes on a form, but only for the current record.
I can get the checkbox to disable the textboxes but it does so for all records on that form which I don't want. Also if I close and reopen the form the checkbox is still checked but the textboxes are re-enabled.
Has anybody any ideas or a different way to approach it I'd appreciate it.
Cheers,
Rob

 

[smedvid]

U should be able to set the Locked property. Here is what I do for a Report form where I have a list box for selecting individual items and a Select All check-box. htwh...

If chkAll.VALUE = 0 Then 'All Box Not Selected
Me.lstStudents.Locked = False 'Unlock SStudents List
Else
Me.lstStudents.Locked = True 'Lock Students List
Me.lstStudents.Requery 'Refresh/Repaint/Clear
End If Steve Medvid
"IT Consultant & Web Master"