edit a form

S

Sibes

I created a form and would like the information in there not to be edited,
unless they click an Edit command button, that i created.. I am not sure how
to do this. any suggestions? or is there a way to do this?
 
H

Hoof Hearted

You need to set the Locked Property to True for all the control in your form,
then put some code behind your Edit Button to set the Locked Property to
false again.

Sub EditButton_Click()
Me![Control1].Locked=False
Me![Control2].Locked=false
End Sub
 
S

Sibes

yes that did work. but now i have run into another problem.
I know unlock all records, not just the current record.
Is there anyway i can put the lock back on for the remaining records?

Thanks for this site...
 
Top