Another approach to what you are describing would be a pair of listboxes.
One listbox would contain all possible attendees who were NOT in attendance
on a given date. The other listbox would contain all attendees who WERE in
attendance.

There are several examples of this in the wizards Access offers.

Conceptually, you are filling the "possibles" listbox from a list of the
people who are NOT in your attendance table for the date. You are filling
the "attending" listbox from the people who ARE in your attendance table for
the date. You are allowing multiple selections in the "possibles" box, and
presenting a button to indicate Attended.

If you add a date field on the form, you can select/enter a date, select
those who attended and click your Attended button, and, as part of the
code behind the Attended button, refresh the listbox lists.

Definitely more than casual programming, but no rocket science...g

--
Regards

Jeff Boyce
Office/Access MVP

"Slider" wrote in message
oups.com...
Hi

The situation is this. I am trying to create a way in which to record
attendance.

I have a table with a list of people called somewhat cryptically LPO (I
did not create the existing database) which contains around 200
records. Attendance for the people in this table has to be marked every
day.

What I want to do is create a form that prompts the user for a date,
then displays a list of these people, the date selected and a field to
record present/not present. I want the user to be able to enter
attendance information for each of these records and record this in
another table (called say "Attendance")

My problem is this. I am able to get this working fine for one "person"
record at a time. However, when I attempt to get it working at
described above I run into two problems.

Firstly, when I create a form that displays all the "person" records
along with fields to record attendance, a change in one of the
"attendance" fields changes all attendance fields.

Secondly, I have yet to find a way to add multiple records at the one
time. What I would ideally like to happen is for the user to enter the
information for all of the records then click an "add all" button at
the bottom that would add all of the records to the table. Currently
all I can seem to do is add one record at a time.

Is what I am after possible in Access or am I going about the problem
all wrong?

Thanks for your help