Form Start Date to default to Table Start Date

[Downie]

I have a form that has a start date value.

I currently have it harcoded as 3/29/2006.
I opened the properties window on the form field and filled out the
default value with #3/29/2006#
This works fine

However would it be possible to have it pull 3/29/2006 from a table
called dates?
I tried filling out the properties window/default value with
{dates.start_date] which has one record
3/29/2006.

It's not working. The form field now displays #Name?

Can you help?

 

[tina]

you can't reference table data that way in a form. try using the DLookup()
function. read up on it in Access Help for details on how it works.

hth