UPDATE tbl_Saved_ShirtStyle INNER JOIN tbl_ShirtStyle ON tbl_Saved_ShirtStyle.OrderNo_ItemNo = tbl_ShirtStyle.OrderNo_ItemNo SET tbl_ShirtStyle.StyleType = [tbl_Saved_ShirtStyle]![StyleType], tbl_ShirtStyle.Collar = [tbl_Saved_ShirtStyle]![Collar], tbl_ShirtStyle.[Mandarin Collar] = [tbl_Saved_ShirtStyle]![Mandarin Collar], tbl_ShirtStyle.[Wing Tip collar] = [tbl_Saved_ShirtStyle]![Wing Tip collar], tbl_ShirtStyle.[Removeable collar stays] = [tbl_Saved_ShirtStyle]![Removeable collar stays], tbl_ShirtStyle.CollarComments = [tbl_Saved_ShirtStyle]![CollarComments], tbl_ShirtStyle.ShirtCuff = [tbl_Saved_ShirtStyle]![ShirtCuff], tbl_ShirtStyle.[Button on sleeve vent] = [tbl_Saved_ShirtStyle]![Button on sleeve vent], tbl_ShirtStyle.Pocket = [tbl_Saved_ShirtStyle]![Pocket], tbl_ShirtStyle.CommentsPocket = [tbl_Saved_ShirtStyle]![CommentsPocket], tbl_ShirtStyle.[Front Plaquet] = [tbl_Saved_ShirtStyle]![Front Plaquet], tbl_ShirtStyle.[Removeable Button panel for Tuxedo Shirt] = [tbl_Saved_ShirtStyle]![Removeable Button panel for Tuxedo Shirt], tbl_ShirtStyle.[Tuxedo Full front fabric] = [tbl_Saved_ShirtStyle]![Tuxedo Full front fabric], tbl_ShirtStyle.FrontPlaquetComments = [tbl_Saved_ShirtStyle]![FrontPlaquetComments], tbl_ShirtStyle.ShirtBack = [tbl_Saved_ShirtStyle]![ShirtBack], tbl_ShirtStyle.ShirtBackComments = [tbl_Saved_ShirtStyle]![ShirtBackComments], tbl_ShirtStyle.Monogram = [tbl_Saved_ShirtStyle]![Monogram], tbl_ShirtStyle.MonoStyle = [tbl_Saved_ShirtStyle]![MonoStyle], tbl_ShirtStyle.Colour = [tbl_Saved_ShirtStyle]![Colour], tbl_ShirtStyle.Placement = [tbl_Saved_ShirtStyle]![Placement], tbl_ShirtStyle.MonoLetters = [tbl_Saved_ShirtStyle]![MonoLetters], tbl_ShirtStyle.MonoComments = [tbl_Saved_ShirtStyle]![MonoComments], tbl_ShirtStyle.[Fabric Inside Collar] = [tbl_Saved_ShirtStyle]![Fabric Inside Collar], tbl_ShirtStyle.[Fabric Inside Cuffs] = [tbl_Saved_ShirtStyle]![Fabric Inside Cuffs], tbl_ShirtStyle.FabricInsidePlaquet = [tbl_Saved_ShirtStyle]![FabricInsidePlaquet], tbl_ShirtStyle.SpecialTrimComments = [tbl_Saved_ShirtStyle]![SpecialTrimComments], tbl_ShirtStyle.ButtonColour = [tbl_Saved_ShirtStyle]![ButtonColour], tbl_ShirtStyle.ButtonHoleThreadColour = [tbl_Saved_ShirtStyle]![ButtonHoleThreadColour], tbl_ShirtStyle.FabricID = [tbl_Saved_ShirtStyle]![FabricID], tbl_ShirtStyle.FabricDetail = [tbl_Saved_ShirtStyle]![FabricDetail]
WHERE (((tbl_ShirtStyle.StyleType)=Forms!frm_SelectStyleShirt!cboStyle) And ((tbl_ShirtStyle.OrderNo_ItemNo)=Forms!frm_SelectStyleShirt!txtOrderNoItemNo) And ((tbl_ShirtStyle.PieceNo)=Forms!frm_SelectStyleShirt!cboPieceNo));