Autofill Question

[Guest]

I have a table that contains all of our current employees and I have a second
table dealing with attendances. These are linked together via a FK from the
attendance table to the employee table.

I have a requirement to fill in the attendance/non attendance etc for each
employee on a daily basis.

Is there any way to open a form that will automatically fill in (for that
days date) all the employees names. i.e i enter the date 09/12/2005 as part
of the parameter when i open the form and i would like to see:-

Jim 09/12/2005
George 09/12/2005
Mick 09/12/2005

etc.....

Is this possible and if so, how is this done?

Thanking you all in anticipation as always

PMK

 

[Van T. Dinh]

You can use code to run an Append Query or INSERT ...INTO ... SQL using the
tblEmployee as the source for the employees and the data entered on the
Form. The Append Query / "INSERT ... INTO ..." will add 1 Record for each
employee with the given date into the tblAttendance.

 

[Guest]

Dear Van T

The simplest solutions are often the most elegant. Your suggestions
absolutey what I required. Many thanks

PMK