I wish to assign Quantity the value of [Quantity]-[OrderAmt]

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello

I have a some related tables (and the relationships work fine on the form)

two of the fields are [tblBrochures]![Quanity] and [tblOrders]![OrderAmt],
both the fields are "single" and bound

I wish to assign Quantity the value of [Quantity]-[OrderAmt]

Can you tell me how to do this please?

Thanks
 
Tony,

Ummm, could be me but I don't get it... Did you mean you want to show the
Balance in a Text Box?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hello

I have a some related tables (and the relationships work fine on the form)

two of the fields are [tblBrochures]![Quanity] and [tblOrders]![OrderAmt],
both the fields are "single" and bound

I wish to assign Quantity the value of [Quantity]-[OrderAmt]

Can you tell me how to do this please?

Thanks
 
Back
Top