N Neo Registered User. Local time Today, 09:31 Joined Mar 5, 2003 Messages 42 Mar 23, 2003 #1 hi Is there a way to press a button on a form and lock all the field from the recordSet in the in that form
hi Is there a way to press a button on a form and lock all the field from the recordSet in the in that form
Fornatian Dim Person Local time Today, 09:31 Joined Sep 1, 2000 Messages 1,394 Mar 23, 2003 #2 Add a flag field to the datasource to say if the record can be edited. Use the OnCurrent event to consider the flag: Me.AllowEdits = Not(Me.MyFlagField) And a button click event to lock the record: Me.MyFlagField = True Form_Current
Add a flag field to the datasource to say if the record can be edited. Use the OnCurrent event to consider the flag: Me.AllowEdits = Not(Me.MyFlagField) And a button click event to lock the record: Me.MyFlagField = True Form_Current