update new records

M

mchicke

I would like to create a form that calls up all records(employees) and amends
their attendance for the new date. I would like to see and edit all
associates, if possible at the same time. I am haing trouble finding how to
create the subform for this.
 
J

John Vinson

I would like to create a form that calls up all records(employees) and amends
their attendance for the new date. I would like to see and edit all
associates, if possible at the same time. I am haing trouble finding how to
create the subform for this.
Click to expand...

A Continuous Subform will display multiple records (view the form's
Properties and set its Default View to Continuous).

If you want to update all records in a table, automatically without
typing data into all of them, an Update query would be the appropriate
tool.

I'm not at all clear what you want updated though!

John W. Vinson[MVP]
 
M

mchicke

I have three tables.
Associates:
ID-pk
Last Name
First Name

Associate Stats:
ID PK
Hire Date
other important data

Attendance:
ID pk
Date
Time in
Time out
other daily data

What I am trying to do is find an easier way do enter information for all
employees at the same time, like a spreadsheet. When I use the form wizard
it sets up a subform for each employee record, and I have to scroll through
each individual and key data. Is it possible to call this data all ot one
time? Maybe I'm missing something.

Cheers,
m
 
Top