Report - List modified fields only!

[BobJr]

Two tables "tblEmployee" and "tblEmployeeHistory".

Each table has identical fields.

Each field on the form "frmEmployee" detects a change (BeforeUpdate) and checks a corresponding box (hidden on the form).

frmEmployee then detects a change (BeforeUpdate) and...

1.) Updates a single ModifiedDate field on the form
2.) Appends the current record to the tblEmployeeHistory table
3.) Updates the tblEmployee table to clear the check boxes

I am currently able to query a date range and get records from the tblEmployeeHistory table and populate a report where I put a checkbox next to each field that has been modified. Works fine BUT...

Ideally I would like to simply list just those fields that have a check and not all of the fields whether the individual field has been modified or not.

Does anyone know how I could accomplish this?

I wonder if I could use vba/DAO to step through the EmployeeHistory table rows w/ date range criteria looking for a check (-1). If it finds a check, grab the field name, value, mod user, mod date and append to a temp table that I could use in the report.

Is this possible or just wishful thinking?

Thanks in advance!

Bob

[Denburt]

I am currently able to query a date range and get records from the tblEmployeeHistory table and populate a report where I put a checkbox next to each field that has been modified. Works fine BUT...

Ideally I would like to simply list just those fields that have a check and not all of the fields whether the individual field has been modified or not.

Does anyone know how I could accomplish this?

True or false in the criteria section should be fine. Adding a simple where statement in the SQL should provide this... Post your SQL code and let us take a look.