DLookUp Error Message

[amond]

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!

[pbaldy]

Your field is text so requires delimiters:

http://theaccessweb.com/general/gen0018.htm

Might need to be tweaked because of the apostrophes in the value.

[pbaldy]

This may be easier:

http://baldyweb.com/Autofill.htm