You can't assign a value to this object - 2448

[philelpko]

Morning all,

Not a clue why the hell this doesn't work so any help is most appreciated!!

Using one form I allow the user to filter the records using combo boxes. Works fine, all the filtered records appear in a column. Next to the filtered records I have 3 command buttons – Print Preview, Print Report & Modify Report. Print Preview and Print work fine, the trouble comes with the modify command button.

The code I use is:

Private Sub Modify_Click()
 
   Dim criteria As String
 
   If Me.NewRecord Then
       MsgBox "Please select a record to view."
   Else
       Criteria = "[ID] = " & Me.[ID]
       DoCmd.OpenForm "Modify Main", , , criteria
   End If
 
End Sub

The form opens up fine, pointing at the correct record but if I try and modify any information in it I get the error “You can't assign a value to this object”.

What is causing me confusion is that if I open form “Modify Main” from “Objects -> Forms” it opens to the 1st record (as you would expect) but it works fine, allowing all information to be edited.

Any pointers are most welcome!

Cheers

Phil

[NeoPa]

Maybe the record you are editing is locked by being selected on your first form.

[MMcCarthy]

As Adrian said your record may be locked by the first form. Try closing the first form after opening the second form. If necessary you can always open it again when the second form closes.

Mary

Morning all,

Not a clue why the hell this doesn't work so any help is most appreciated!!

Using one form I allow the user to filter the records using combo boxes. Works fine, all the filtered records appear in a column. Next to the filtered records I have 3 command buttons – Print Preview, Print Report & Modify Report. Print Preview and Print work fine, the trouble comes with the modify command button.

The code I use is:

Private Sub Modify_Click()
 
   Dim criteria As String
 
   If Me.NewRecord Then
       MsgBox "Please select a record to view."
   Else
       Criteria = "[ID] = " & Me.[ID]
       DoCmd.OpenForm "Modify Main", , , criteria
   End If
 
End Sub

The form opens up fine, pointing at the correct record but if I try and modify any information in it I get the error “You can't assign a value to this object”.

What is causing me confusion is that if I open form “Modify Main” from “Objects -> Forms” it opens to the 1st record (as you would expect) but it works fine, allowing all information to be edited.

Any pointers are most welcome!

Cheers

Phil

[philelpko]

Cheers for the help guys :)

As was pointed out by Adrian the filtered form was locking the form.

Incase anyone else suffers from this school boy error like myself the simple solution in my case was (in design mode) go to Properties -> Form (this is the filtered form that is being edited).

Select the 'Data' Tab and you should find a field called 'Record Locks'. Change this to 'No Locks' and all is well.

[MMcCarthy]

Cheers for the help guys :)

As was pointed out by Adrian the filtered form was locking the form.

Incase anyone else suffers from this school boy error like myself the simple solution in my case was (in design mode) go to Properties -> Form (this is the filtered form that is being edited).

Select the 'Data' Tab and you should find a field called 'Record Locks'. Change this to 'No Locks' and all is well.

Just one thing in a multi user environment this can be dangerous as two users trying the edit a record concurrently can cause corruption. Although this may not be a common occurance it does happen.

Mary