I want to set a value equal to the value in field SparePartsID that is on subform sfJpbSpareParts that is embedded in form fMaintRequest and can not seem to get the syntax correct. Can anyone be of help? Thanks.

This link should help:
http://www.mvps.org/access/forms/frm0031.htm

HTH RuralGuy (RG for short) aka Allan Bunch MS Access MVP 2007 acXP WinXP Pro

YES IT DID!!! Thank you so very much. I was totally "stuck" on this issue. I have to go find my cat now, I think that I scared him when I did the Happy Dance after this code worked:

Dim SQL_Text As String
    SQL_Text = "UPDATE tSpareParts SET [tSpareParts]![SP_Units_On_Hand] = [tSpareParts]![SP_Units_On_Hand] - Forms!fMaintrequest!sfJobSpareParts.Form!SparePart sUsed WHERE [tSpareParts]![SP_Part_Number] = Forms!fMaintrequest!sfJobSpareParts.Form![SparePartsID]"
DoCmd.RunSQL (SQL_Text)

Glad I could help.

__________________
HTH RuralGuy (RG for short) aka Allan Bunch MS Access MVP 2007 acXP WinXP Pro