How to UPDATE table from textbox on form

[BrockWade]

I am trying to update a table's field from a text box on a form.... I'm using this code which is not working... any clues? Thanks!:



Private Sub Command125_Click()
DoCmd.RunSQL "UPDATE tblFinals SET ChangeOrdersInTransit = Me.txtStatementBalance"
End Sub

[orange]

Update queries can be unforgiving.
This would update all records to Me.txtStatementBalance
If this is a text field then

Private Sub Command125_Click()
      DoCmd.RunSQL "UPDATE tblFinals SET ChangeOrdersInTransit = '" & Me.txtStatementBalance &"'"
End Sub

[BrockWade]

What if instead of a textbox it is pulling data form a subform called Child99?

[orange]

How come you're changing the question?

How about clearly stating WHAT you want to do in plain English?

[Xipooo]

What if instead of a textbox it is pulling data form a subform called Child99?

Then Me.child99.txtStatementBalance