displaying a date using DLookup

[crowegreg]

On a form, I have a combobox. The user selects a record from the combo box. Their are fields that are populated once the combobox selection is executed. Here's a sample dlookup funtion that is working:
=DLookUp("FreightPO","tblProductPrintRuns","PrintR unID ='" & [Combo7] & "'")

If the field is a date field, when the form is opened, the date field is flashing. Upon making a combobox selection, within the date field, the error is #Name


Here is the dlookup function within the date field:
=DLookUp("Pick-UpDate","tblProductPrintRuns","PrintRunID ='" & [Combo7] & "'")

What do I need to fix? Thanks in advance!

[boblarson]

Because of the special character (the dash - ) you have in the field name, you need to put it in square brackets:

=DLookUp("[Pick-UpDate]","tblProductPrintRuns","PrintRunID ='" & [Combo7] & "'")

(It makes life SOOOOOO much easier if you do not use special characters or spaces in object or field names)

[crowegreg]

Thanks Bob. As we all know, we learn best by our mistakes.

I'll change the field name.