On Wed, 26 Jan 2005 07:35:04 -0800, "mchicke"
wrote:

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?

Probably this can be handled at the form level. Use a mainform (which
might be unbound) with a textbox for the desired date, and a Subform
based on your attendance table using this textbox as the Master Link
Field and the date as the Child Link Field. (By the way, do NOT use
Date as a fieldname; it's a reserved word and Access will get
confused).

You can then have the subform as a continuous form with the
associateID bound to a combo box allowing you to select each
associate's name and enter their times.

John W. Vinson[MVP]