Hi,
I am intermittently getting a runtime error, "you cant assign a value to this object".
I'll start with the section of code;
The section that error comes up on is
Me.chkFileInUse.Value = True
This is a bound control and is enabled. The checkbox is in the details section of the form
I've tried running this on the form's load,activate,open and now current events and still getting the same intermittent issue.
I'm not sure what additional information you need, please let me know.
Any ideas?
Thanks!
I am intermittently getting a runtime error, "you cant assign a value to this object".
I'll start with the section of code;
Code:
Private Sub Form_Current()
On Error GoTo Error_Form_Current_Click
Dim initialNotify As Boolean
Forms![frmAccountDisplay].Refresh
If initialNotify = False Then
If Me.chkFileInUse = True And Me.txtUserCheckout <> getUserName_check Then
MsgBox "Account is currently being accessed by" & " " & Me.txtUserCheckout & vbCrLf & vbCrLf & "You cannot make changes to the file!.", vbOKOnly, "Account Already in Use"
Forms("frmAccountDisplay").AllowEdits = False
Me.bttnLoadMerlin.Enabled = False
Me.bttnFindMatch.Enabled = False
Me.bttnCloseFlie.Enabled = False
Me.bttnSaveComments.Enabled = False
Me.bttnAddMgrCmnt.Enabled = False
Me.bttnSaveFile.Enabled = False
Else
Me.chkFileInUse.Value = True
Me.txtUserCheckout = getUserName_check
Forms![frmAccountDisplay].Refresh
initialNotify = True
End If
End If
Exit_Error_Form_Current_Click:
Exit Sub
Error_Form_Current_Click:
MsgBox Err.Description
Resume Exit_Error_Form_Current_Click
End Sub
The section that error comes up on is
Me.chkFileInUse.Value = True
This is a bound control and is enabled. The checkbox is in the details section of the form
I've tried running this on the form's load,activate,open and now current events and still getting the same intermittent issue.
I'm not sure what additional information you need, please let me know.
Any ideas?
Thanks!