calpolymis1
MIS
Hi. I use the following code to manipulate allowedit property on various forms in my database. With a command button, I can successfully lock/unlock the record. Today, I've encountered a form that doesn't allow this. The following is the code I put in Form_current event.
Private Sub Form_Current()
If Me.NewRecord Then
Me.AllowEdits = True
Me![Serial Number subform].Form.AllowEdits = True
Else
Me.AllowEdits = False
Me![Serial Number subform].Form.AllowEdits = False
End If
End Sub
This form is from a database I created long time ago, and except Microsoft Calendar Control 10.0, it has same references with my other working databases. I spent the whole day to figure out this, but no luck. what could be a reason? I tried various codes in addition to above one, but no luck. Thanks in advance.
Private Sub Form_Current()
If Me.NewRecord Then
Me.AllowEdits = True
Me![Serial Number subform].Form.AllowEdits = True
Else
Me.AllowEdits = False
Me![Serial Number subform].Form.AllowEdits = False
End If
End Sub
This form is from a database I created long time ago, and except Microsoft Calendar Control 10.0, it has same references with my other working databases. I spent the whole day to figure out this, but no luck. what could be a reason? I tried various codes in addition to above one, but no luck. Thanks in advance.