Hi,

How do I link the values in a textbox on a form to an entry in the SQL string.

For example:

UPDATE tlbPartsTable SET tlbPartsTable.ItemsInStock =

[tlbPartsTable].[ItemsInStock]-frmReqTransaction.txtQuantity
WHERE ((([tlbPartsTable].[PartID])=frmReqTransaction.txtPartID));

Here frmRequistion is the form (It is not linked to any data source)...
txtQuantity, txtPartID are textboxes...
tlbPartTable is the table where data is retrieved....

thanks
arun