Im getting a pop up error saying 'Update or CancelUpdate without AddNew or Edit.'
It occurs when I attempt to set the value of a textbox, txtFeeAmount (bound) to a value within another textbox, txtDepositFeeAmount
txtFeeAmount is contained within a subform, where txtDepositFeeAmount is on the Parent form.
--Line that causes the error--
Me.AdjustmentsForm.Form.txtFeeAmount = Me.txtDepositFeeAmount
The 'strange' thing is that the error only occurs when the recordset of the subform contains only one record, when it contains multiple records it works fine!
The code is contained within the Exit event of the txtDepositFeeAmount textbox.
Any help/info would be appreciated
p.s. Me.Dirty equals false when this happens.