Date update Macro

[Robert B. Rogers Jr.]

I have a form that is filter to show all records for a
specific date that is entered into a table. I would like
the date to update to the current date upon opening the
database and then be able to select a new date there
after. I felt that the best way to do this was with a
macro that runs only upon opening the database. I have
tried several expressions, but I cannot seem to get
anything to work. Does anyone have any suggestins on how
to do this? Or is there a better way than a Macro? I am
running Windows 2000 and Office 2000.

 

[Ken Snell [MVP]]

Create and save an update query that will update the date value in that
table to the current date.

Then use an AutoExec (that is the name that you give to the macro) macro to
run that query (OpenQuery). A macro named AutoExec is run when the database
is first opened.