How complex the table default value could be

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
 
D

Duane Hookom

You can't have a field default depend on user-defined functions or other
fields/data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default Value =now() in table 2
Obtain Top Value from Table 9
Create A List Of Dates In A Month 17
Query/Function/Parameter Troubles... 2
default value 6
Expression As Default Value in Control Properties 2
Sum of values in a form 0
date value expression and syntax 1

Top