how to assign a default value into a field from data in another table? 1

[dataplayer]

In my data entry form, there is a field called "Year" where I want a current year value from another table or query as the default. It should not be difficult I feel, but I just don't know how. Could anyone enlighten me. Thanks.

 

[mordja]

dataplayer,

In the default value of your field year simply use a

dlookup("[yourYearField]","yourTableOrQueryWithYear")

where you replace yourYearField with the name of the field containing the year you wish to use and yourTableOrQueryWithYear with the name of the table or query you wish to use. As there is no criteria this will select the first match.

Mordja

 

[dataplayer]

Mordja,

It works! Thank you very much.