I have had a good read through the forums and tried several of the examples but to no avail.

I have a form called "Parts_Used", which has several fields that are all lookups to various fields in another form called "Parts_List".

I have currently got it working so when I choose a category it only filters the part descriptions under that category and then like wise I have a 3rd field that only shows the part numbers that are relevant to the part description.

What I need is that when I have selected the Part No. the 4th field, which is called "Cost", auto populates itself with the the value in the relevant field in the "Parts_List" form, called "Estimate_Cost".

Any help again would be greatly appreciated

MattP