Default value from another table

  • Thread starter Thread starter Jerry Crosby
  • Start date Start date
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
 
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
 
Back
Top