inform user of additions

[pjharris]

I've been lurking for a while now and have learned quite a bit from this forum, but now, I'm stumped.

Currently, I have a form that automatically updates on startup via an ODBC database. I disabled the append query warning, but I realized I need to tell the user what records, if any, have been added so they don't have to scroll through the form to find the new records. Also, I want to do something similar on exit where old records are stored in a different table for archive purposes.

I know this is something needing a message box, but how to put that info into the message box is my issue.

Thank you in advance.

 

[scottn]

can you change the table design? if so, one approach might be to add a field to the table so that you could date-stamp the records as they were added (you could also stamp edited records if you wanted users to be able to see any new changes). then keep a log of which users logged in when, and then when a user logs in you can query the table for all records stamped since that user's last login. i suppose you could show the results in a message box, but with a little extra code you could add a button to allow the user to filter the form's recordset to show only those new records...