I currently have two forms, frmAccountData and frmUnderwriting. I want to update the dblPTI field on the frmUnderwriting form if the user changes the curPmtAmtNew field on the frmAccountData form with an afterupdate event. Currently, I'm getting a run time error 2448, you can't assign a value to this object. Why am I getting this error and how can I fix this?

Your subform is not updateable. Or is it? Can you make updates to your subform by entering text? If so, then perhaps you are not referring to the field properly.

How are you making the update? Are you updating the record in the table, or are you assigning a value to the text box on the subform?


mmcdonal

It's actually two different forms. I want to update the dblPTI text box to my table.

You are probably getting an error because the other form is not open, although that is usually a can't find form error.

I would go right to the table level with this one.

You could create an update query, and then for the Update to: post the name of the open form and text box, like:

Update To: [Forms]![frmAccountData].[curPmtAmtNew]

Then just run the query:

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryYourUpdateQuery"
DoCmd.SetWarnings True

If that doesn't work, we can just do code. You could also open the other form Hidden, make the update and then close it.

HTH

mmcdonal

Thanks! I'll try both of these. I appriciate your help.