Fill field on a subform from another form

[geno]

HI,

I have an order form with an order details subform.
When the user enters in a part number the description and selling cost are auto filled.
Sometimes the user will change the selling cost on entering through the record.
Problem is that the users are entering through these records again and changing back the changed selling cost to the set one on the part.
I've created a form to open if a part was sold to the customer more than once so the user can see the last selling price.
I'm trying to auto fill the cost field with the last cost change but am at a wall.
Also there can be more than one cost change so I need the most recent to auto fill the subform details selling cost.

Thanks for any help

 

[JHB]

Can't you use a query to look up last selling cost?
Run it in the AfterUpdate event for the "part number" control.
For further help, I post a stripped version of your database with some sample data, (zip it).

 

[geno]

Thanks for your post, I got it to work.