Entry Date

[cmw]

A Bound Form contain one date field,that date value assign,all form new record 'defaultvalue' date. How can assign query or macro?

 

[namliam]

You dont... just use the default value for the date field... and put in =Date()

 

[cmw]

One table contain namely Entry date, this table contain one date value. That date value assign all new entry form date default value

 

[namliam]

?? You want to have one date in one table someplace and have that be the default date for all records??

WHY?

 

[cmw]

All form date field default value is current date, but i dont want current date I enter a date in Entry Date Form, This date assign all new record default date. So I want a table contain one date field, Entry date form date value is stored into that table. This table value assign default value date. I think this way, pls tell me any idea .

 

[namliam]

You could make a function something like so:

Function FetchDefaultDate() As Date
    FetchDefaultDate = DLookup("fieldname", "TableName")
End Function

This fetches the default date from a table, you can then use the form to use the function as default value for the field.

 

[cmw]

Thank you very much namliam. Its work well.I write Date field properties defaultvalue =FetchDefaultDate() ,Its dont display date. So i write Event code, Date display.

 

[namliam]

Glad to be of assistance