How to update a filed within a Form

[TrickyDicky]

So I have a Form which I input details of a job I've done.
Its in a table format, what I need to do is when I select a part that I have used I want the price of that part to update automaticly in the next field. I have a seprate form that that has all the infomation of that part.

Thanks all

Screenshot: -
The fourm with the field that needs to be updated Automaticly

Where that infomation comes from

 

[Simon_MT]

You can either create a query and create a Join into Parts_Detail and after Update on Parts set the [Part Cost] on your edited record [Part Cost] = Parts_Detail.Part Cost

Or

On your Combi put the Part Cost into the Select statement. Set the column width = 0 if you want to hide it then After Update set your edited record to:

In [Part Cost] = [CombiParts].Column(6).

Depending on your method you will need assign the Form; me. in a Sub or With CodeContextObject just a dot using VB.

Simon