Access Sub form Saying Read-only

Oludare

New member
Local time
Today, 17:47
Joined
Jan 28, 2021
Messages
24
Hello All.
I have a checkbox on my form but after checking the box it says the form is read-only. I have placed the below code Me.AllowEdits in the subform Load event,
however it did not fix it.

Regards
 
You didn't include the code. Forms can be read-only because of the way they are opened, because of the Allowxxxx options, or because the form's underlying .RecordSource is read-only. And you said "Form" but then you placed something in the subform's Form_Load event. Where is the checkbox?
 
Hello The_Doc_Man,

The form_Load event of the subform(frmReissueDataSheet) has the code Me.AllowEdits = True
The Sub form is called from the main form with the below code:
rs.Open cmd, , adOpenKeyset, adLockReadOnly
Set Me.frmReissueDataSheet.Form.Recordset = rs

The check box is located on the subform(frmReissueDataSheet).

Thanks for your help.

Regards
 
rs.Open cmd, , adOpenKeyset, adLockReadOnly???
 

Users who are viewing this thread

Back
Top Bottom