Form Start Date to default to Table Start Date

  • Thread starter Thread starter Downie
  • Start date Start date
D

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?
 
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
 
Back
Top