refering to a field that is not in a form

shutzy

Registered User.
Local time
Today, 22:38
Joined
Sep 14, 2011
Messages
775
i would like to know if it is possible to refer to a field even tho it is not in a form

ie
PHP:
strSql = "UPDATE tblItems " & _
 "SET StockQTY = ([StockQTY]+1) " & _
 "WHERE ItemsID = " & [ItemsID] & ""

the [ItemsID] is actually on the form as a txt box. but i dont really need it there for any other purpose other than the vba above.

in the form i have a field that is in the form as a txt box that has a relationship to the ItemsID. i have attached a image of the relationship.

the field that is in the form is tblOrdersItems.OrdersItemsID and i also have tblItems.Items. so rather than adding another meaningless txt box to the form(ItemsID) i would like to be able to use the relationships to get the correct ItemID

thanks for any help
 

Attachments

  • relationships.jpg
    relationships.jpg
    24.9 KB · Views: 108

Users who are viewing this thread

Back
Top Bottom