Textbox based on a Combo Box Selection

[accessbuddy]

I have a Quote form and when I select a Process from the Process Combo box on this form I want the Price to appear in a textbox. When I added the existing fields, Process 1 price appeared when the Process 1 combo box was selected. However, I added Process 2, PRocess 3...Process 10. i want the price text box to relate to each of these combo boxes individually. The Processes are stored in the Processes table with 4 columns:
1st column - process id
2nd column - process
3rd column - set up cost
4th column - total price per unit

I tired using DLOOKUP but it results in #name?

[ranman256]

Have the form connect to the same table as the combo box.
Then when the user picks the process ID, filter the form to this ID and all the text boxes will fill instantly.

combobox afterupdate event:

me.filter = "[processID]=" & cboProssID
me.filteron = true

[accessbuddy]

Thanks for your reply!

How would I do this because the materials, threads, blocks , employee name, client name are all also linked to this form?
Also where would I type in this code?

Thank you again!