Can't assign value

  • Thread starter Thread starter Mike Collard
  • Start date Start date
M

Mike Collard

I have form with several text boxes that are populated by
a procedure triggered by the On Open event of the form.

I want to create a Cancel button to undo any unsaved
changes so I have copied the following code from the
Access Help file but get 'error 2448. Can't assign value
to this object.'

Sub btnUndo_Click()

Dim ctlC As Control
' For each control.
For Each ctlC In Me.Controls
If ctlC.ControlType = acTextBox Then
' Restore Old Value.
ctlC.Value = ctlC.OldValue
End If
Next ctlC

End Sub

Any ideas?

Thanks
 
Mike,

The "OldValue" property only applies to bound controls, and it
sounds like you are using unbound controls on this form.

Instead, how about running the code that loads values into your form
when they press Cancel, that way they are in the same position as when
they started?

-td
 
Back
Top