Unable to edit subform

[stephanie.g]

I am using a button to open a specific record from a listbox. The main form is editable, but my subforms are locked. This is the code I am using to open the form.

Private Sub View_Click()
Dim SelectedProfileID As String
Dim SelectedCustomer As String

SelectedProfileID = Me.lstResults.Column(0)
SelectedCustomer = Me.lstResults.Column(1)
DoCmd.OpenForm "frmCustomerRecord", , , "[ProfileID]='" & SelectedProfileID & "'", acFormEdit

Any help making the subforms editable would be appreciated. I am brand new to this, so maybe my code is all wrong.

 

[pbaldy]

Are they editable if you open the form a different way? Nothing in that code would lock them.

 

[stephanie.g]

It is now working. I swear I checked four or five times to make sure my forms were not locked and they were all fine. I am sure it must be a PICNIC error.

Thank you!

 

[pbaldy]

Glad you got it working.