How complex the table default value could be

  • Thread starter Thread starter marwan
  • Start date Start date
M

marwan

I used the followinf equation in my date/time field default value
=IIf(Month(Date())>=7;DateSerial(Year(Date());7;1);DateSerial(-1+Year(Date()
);7;1))
this eqation worked fine, inspite of the function iif is not listed in the
expression builder built-in functions.
but when I tried to use the Dlookup function I received an error message.
is this particular function not allowed ?
What are the limitations in the tables default values in general?
Thanks
 
You can't have a field default depend on user-defined functions or other
fields/data.
 
Back
Top