Hi,
I have set up a query e.g. query1, it produces 5 fields with stable data.
I use one of these data unit Cost price to produce a cost related to an added field Quantity that i fill in by hand. The cost price is calculated as unit Cost price * Quantity this cost price is then set in the form Form1.
Once the field Product Name is selected in the first combo box of the Form1, I wish having that field update all the other four fields in particular the unit cost price.
How do I do that?
Thank you
I have set up a query e.g. query1, it produces 5 fields with stable data.
I use one of these data unit Cost price to produce a cost related to an added field Quantity that i fill in by hand. The cost price is calculated as unit Cost price * Quantity this cost price is then set in the form Form1.
Once the field Product Name is selected in the first combo box of the Form1, I wish having that field update all the other four fields in particular the unit cost price.
How do I do that?
Thank you
