Access Sub form Saying Read-only (1 Viewer)

Oludare

New member
Local time
Today, 13:34
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
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 08:34
Joined
Feb 28, 2001
Messages
27,001
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?
 

Oludare

New member
Local time
Today, 13:34
Joined
Jan 28, 2021
Messages
24
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
 

bastanu

AWF VIP
Local time
Today, 06:34
Joined
Apr 13, 2010
Messages
1,401
rs.Open cmd, , adOpenKeyset, adLockReadOnly???
 

Users who are viewing this thread

Top Bottom