Default value of the field

  • Thread starter ljubo lecic via AccessMonster.com
  • Start date
L

ljubo lecic via AccessMonster.com

Is it possible to define the default value for the field
in the table design to be the value of the field from another table.
(Dynamicaly defined default value)
I tried to write the subquery in the expression builder
but have some syntax errors.
Whereas I am not very familiar with the expression builder I need help.
Thanks in advance!
 
J

John Vinson

Is it possible to define the default value for the field
in the table design to be the value of the field from another table.
Click to expand...

No. This violates relational principles and is therefore not
available.

You can set the Default property of a control in a Form (the form you
should be using to enter data into your table) to a DLookUp()
expression retrieving a value from a table, but you can't do it in the
table properties.

John W. Vinson[MVP]
 
Top