Default date

  • Thread starter Thread starter Adam Whitehouse
  • Start date Start date
A

Adam Whitehouse

I have linked tables in Access 2002 where the master table
has the default value in a date field set to '=date()'.
Today's date appears in this table, but not in the linked
table in another database (#NAME? appears). I've
refershed the link, but without it making any difference.

Can anyone shed some light on this?

Thanks

Adam
 
Have you linked the primary key in the main table to a
corresponding foreign key in the other table?
 
Back
Top