Update table with listbox values

[lfazenbaker]

I am trying to update a record using textbox values. Why won't this work?

DoCmd.RunSQL "UPDATE Families SET & _
"[Reason] = '" & txtReason.Value & _
"', [RentAmt] = '" & txtRent.Value & _
"', [Utilities] = '" & txtUtilities.Value & _
"', [PantSize] = '" & txtPant.Value & _
"', [ShirtSize] = '" & txtShirt.Value & _
"', [ShoeSize] = '" & txtShoe.Value & _
"', [CoatSize] = '" & txtCoat.Value & _
"', [Gift] = '" & txtGift.Value & _
"', [IncomeSource] = '" & txtIncSource.Value & _
"' WHERE FamilyID = '53';"