Storing Values

[Nexus]

how is it that i can store values of one form into one
table but i can't do likewise for the values of another
form in another table that has query pointing to that
table as its record source?

Example:
-This codes can work in its form-
strEmployee = LastTransactionEmployeeID
LastTransactionEmployeeID = cmbEmployeeID.Column(0)

-This codes are similar but cannot work in its form-
intQty = PurchasedQty
PurchasedQty = txtTransactionQty

 

[Wayne Morgan]

The first thing to check is the query. Open the query feeding the form that
won't update. Can you type directly in the query and make the update? If
not, then the query isn't updateable and so the form won't be either.