Hello guys!
My ultimate objective is for users to use this form as a quoting tool. I have a table with shed sizes and prices:
The tool would allow the user to use a dropdown to choose a unit size and get a price:
The error message I am getting in that textbox comes from a DLookUp function that I have used as my control source:
Combo44 is the combo box for the unit size. How can I get the price to show up there? Am I doing something wrong with my function?
Your input and ideas are appreciated!