I think my problem may be deeper. I have a query set up of all 'Active'
associate which returns their Name and ID#. I am then trying to link to the
Attendance table with the fields ID#(the relationship to return names) Date,
Time in and time out. I would like to be able to edit all active associates
for a new date all at once, instead of moving record by record of each
employee in the main form and entering the data in the subform. The problem
may lie in my tables or queries?

"Duane Hookom" wrote:

You could use a continuous subform on a main form. Add a text box on the
main form for the date. Then set the link master child properties of the
subform control to the text box and the date field in the subform. Each new
record in the subform will default to the date from the text box on the main
form.

--
Duane Hookom
MS Access MVP


"mchicke" wrote in message
...
I am having trouble(i'm a newbie) finding a way to generate a form to enter
data for a group of active employees by date. The only way I can see to
do
it now is to scroll individually through eash employee's record, and
update
that way. I would like to enter a date, and add records for that date for
all employees in the same form. Any help would be greatly appreciated.