Update temp table when form closes

[ad2]

Hi,

I have an application that has several forms. At the end of the day the manager wants to run a report of all the records entered that day from all froms. I have a field on each table, RecordDate, that captures the date the record was created.

I was thinking of creating a temp table, and have each form write the form id and subject id to the temptable. I was thinking of having code that would do this on each form's on close event.

Would eanyone have an example of VB code that would write fields to another table?

Thanks, Ad2

 

[randy700]

Why add an extra table? Since you all ready have a field that indicates when the records was created, why not just run a query to get a complete list of the day's entries?


Randy

 

[ad2]

Too many forms, query give false results. But I'll work on it