Auto fill field in subform (like Unit Price)

[Smirl]

Hello,
This has been bugging me for hours now and im sure the answer is right in
front of me. I am creating a order management database based on the template
from office online. I have adapted the tables to have some field specific for
my purpose.

I would like to know how to automatically fill in a field by selecting the
product from the list. Those familier with Northwind Database will know that
the Unit Price automatically fills in. I have a similar field called CC Value
which changes over time so needs to be in the Order Details table.

If i need to explain this better i will. Thank you for your help in advance.

Alex

 

[Smirl]

I have found the answer now. It took me a while but i got there.

With the template I am using there is a macro which I would edit which is
run on an afterupdate event. I added to the line of the macro that was being
run using a "setValue".

Its all good now.

Hope this helps someone else.