Default values in access forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to set the defaul;t value in the form to the value in another table.
eg the default value for the year to be 2005. if this is a value in another
table then the default value in various forms can by updated by changing the
value in the table.
 
merlinchris said:
i want to set the defaul;t value in the form to the value in another
table. eg the default value for the year to be 2005. if this is a
value in another table then the default value in various forms can by
updated by changing the value in the table.
Click to expand...

Use a DefaultValue setting of...

=DLookup("FieldName","TableName")
 
Back
Top