CODEWITHSUNDEEP
ms-accessvba
PowerUser
PowerUser

Reputation: 11801

Cannot edit data in an Access form

I'm developing a small Access 2003 DB with 2 forms. The user first enters FrmMain and if a record interests them, they can go to FrmDetails (kind of like a 'drill-down' style). This second form allows the user to leave comments, change a few values, etc. and is called with the following code:

Private Sub Cmd_GoToDetailsForm_DblClick(Cancel As Integer)
   DoCmd.OpenForm "FrmDetails", , , _
      "[TblF1-Main].[The_ID]=""" & Me.The_ID.Value & """"
End Sub

Here's the problem, the user can't edit any of the fields in FrmDetails. Why not and can you suggest a fix?. More facts about my problem:

Upvotes: 0

Views: 10416

Answers (2)

PowerUser
PowerUser

Reputation: 11801

Found the answer finally. For no particular reason, I had set FrmMain's Record Lock's property to All Records (The default setting is No Locks). Since both forms were based on the same table, I'm guessing that the 1st Form locked the records for the 2nd form. @mwolfe02, Thanks for your help!

Upvotes: 1

Kovags
Kovags

Reputation: 540

Is FrmDetails being opened as a sub form of FrmMail? If so, check whether the SubForm control is Locked or not.

After that, check whether the form FrmDetails has the property Allow Edits and Allow Additions are set to Yes or No.

Upvotes: 0

Related Questions