Default values in access forms

M

merlinchris

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.
 
R

Rick Brandt

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")
 
Top