Display records added since last time opened

[Melinda Chase]

Hello,
I have a form that I'd like to filter to show the records that were added
since the last time I opened the database. So far, I've added a table to my
personal front end to store the date I last opened the database
(tblDateLogged). I've set up a form filter (which works when I type in a
date). I've tried adding code to the form to log the date when I close the
form. That's the part that isn't working. I tried the On Close event, but
it said it couldn't find my table. I'm really not sure how to proceed. I
want the date to get overwritten each time.
Any ideas?
Thanks,
Melinda

 

[Marshall Barton]

I have a form that I'd like to filter to show the records that were added
since the last time I opened the database. So far, I've added a table to my
personal front end to store the date I last opened the database
(tblDateLogged). I've set up a form filter (which works when I type in a
date). I've tried adding code to the form to log the date when I close the
form. That's the part that isn't working. I tried the On Close event, but
it said it couldn't find my table. I'm really not sure how to proceed. I
want the date to get overwritten each time.

The code in the Close event could be like:

CurrentDb.Execute "UPDATE tblDateLogged " _
& "SET datefield = Date()"

 

[Klatuu]

Add:
, dbFailOnError

 

[Melinda Chase]

The code in the Close event could be like:

CurrentDb.Execute "UPDATE tblDateLogged " _
& "SET datefield = Date()"

I'm missing something here.
Here's what I put in:

CurrentDb.Execute "UPDATE tblDateLogged" & "SET DateLogged=Date()",
dbFailOnError

When I close the form, I get a 3144 error. What did I do wrong?
Thanks,
Melinda

 

[Marshall Barton]

I'm missing something here.
Here's what I put in:

CurrentDb.Execute "UPDATE tblDateLogged" & "SET DateLogged=Date()",
dbFailOnError

You left out a critical space:

CurrentDb.Execute "UPDATE tblDateLogged SET
DateLogged=Date()", dbFailOnError

 

[Melinda Chase]

You left out a critical space:

CurrentDb.Execute "UPDATE tblDateLogged SET
DateLogged=Date()", dbFailOnError

Thanks Marsh,
That did it!
Melinda