Default value from another table

J

Jerry Crosby

How do I set the default value for a field on a form to be a value that is
stored in a table that is not in the query for the form? Use a simple
DLookup function? Something else?

Jerry
 
O

Ofer

Set it on the on current property of the form
me.FieldName=dlookup("FieldName","TableName","WhereCondition")

Instead of creating s default for the field, it does the same thing
 
Top