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?