Cannot Save unbound text

Originally Posted by jamesnkk

I have an unbound text - txtfreight on a Subform, when I enter a value , it does not save to the Main form table immediately, unless I close and open up the form. How can I force to save immediately so that I can preview report , since report would be reading the values from the from the underlying table rather than the open form.

I have tried using Forms.frminv.Recalc or Requery , ok this time it save but it cause all other calculated unbound texts value to display #error and keep looping So I remove the Recalc or Requery

How can I resolve it ?

1. In the After Update Event -
2.
3.Forms.frminv.freight = Forms.frminv.frmSubInvoc.Form.txtFreight
4.DoCmd.RunCommand acCmdSaveRecord
5.' forms.frminv.recalc ' Remark off as cause hang

In the Default Value -
=[Forms]![frminv]![Freight]

Originally Posted by jamesnkk

I have an unbound text - txtfreight on a Subform, when I enter a value , it does not save to the Main form table immediately, unless I close and open up the form. How can I force to save immediately so that I can preview report , since report would be reading the values from the from the underlying table rather than the open form.

I have tried using Forms.frminv.Recalc or Requery , ok this time it save but it cause all other calculated unbound texts value to display #error and keep looping So I remove the Recalc or Requery

How can I resolve it ?

1. In the After Update Event -
2.
3.Forms.frminv.freight = Forms.frminv.frmSubInvoc.Form.txtFreight
4.DoCmd.RunCommand acCmdSaveRecord
5.' forms.frminv.recalc ' Remark off as cause hang

In the Default Value -
=[Forms]![frminv]![Freight]

Originally Posted by puppydogbuddy

See below:

1. In the After Update Event of txtFreight on subform
2. If Me.Dirty Then

Me.Dirty = False

Originally Posted by jamesnkk

I tried but don't work, it cause other calculated unbound textboxes display "#error".

Originally Posted by puppydogbuddy

Can you step thru/debug the code and tell me which line is generating the # error. Maybe the code sequence is not correct. More info would be helpful...that is... if you are still interested in pursuing this in light of your statement that the refresh method works for you.