Hello,
I have a subform bound to a table.
The fields in the subforms are locked.
How to unlock them?
Allow Add/Edit/Delete are enabled.
I am not sure what is the problem here.
Can someone help me on this.
Competent Performer
Windows 7 64bit 
Access 2013 64bit
Hello,
I have a subform bound to a table.
The fields in the subforms are locked.
How to unlock them?
Allow Add/Edit/Delete are enabled.
I am not sure what is the problem here.
Can someone help me on this.
Who is John Galt?
Windows XP Access 2007
The individual controls have locked and enabled properties. Are they set appropriately?
Competent Performer
Windows 7 64bit Access 2013 64bit
Yes.
The Individual controls are not locked and enabled as yes.Originally Posted by pbaldy
Virtually Inert Person
Windows 10 Access 2016
need more info about what is happening. Maybe there's a message in the system tray saying the recordset isn't updatable, as in it is of the type that cannot be edited.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Who is John Galt?
Windows XP Access 2007
Is the subform bound to a table directly, or a query that might be read-only?
VIP
Windows 7 64bit Access 2007
Also...does the Subform Control (which holds the Form the Subform is based on) have Enabled set to Yes and Locked set to No?
Is AllowEdits for the Main Form set to Yes? If the Main Form cannot be edited (for whatever reason) data on the Subform Control cannot be added/edited.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Possibility to unlock all access functionalities
lock and unlock buttons
external accdb won't unlock
Posting Permissions
Reply With Quote