calculating from other forms - Please Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my product form I have created an average price for each product through
the subform which is my transaction table. I have made forms such as a
WasteForm and a Usage Form. Both of these forms feed into the transaction
table. I have set up the the forms with date, product, quantity waste, Price
- My question is this - How I want my waste form to automatically fill in the
price once the product has been selected. I want this price to be the
average price from the product form. Is this possible. I would need some
detail how to do this. Thank you in advance
Zenia
 
Hi Zenia,

I'm not sure I completely followed your question, but in general you can
refer to values on other forms by referring to the control name using the
format:

Forms![YourFormName]![YourControlName]

If the value that you are trying to reference is contained in a control on
the other form, I think that this should resolve your problem, but if that is
not it, please post back with a little more detail.

HTH, Ted Allen
 
Back
Top