Attendance forms - ticklist

[FredMcStaire]

I run a sporting club of about 80 people of whom 40 may be in attendance on any one night. I would like to have a form that displays every members name and a tickbox ( or something similar) next to it, so I can simply tick off the members as they come in ( or they can tick their own name). Other solutions with members' names appearing in drop down boxes are rather cumbersome in our particular situation.

We currently use a db to track attendance at different events such as games, skills course,demonstrations, come and tries. The tables are pretty standard now:

Members
Unique ID
name
contact details

Event
Unique ID
Category
Detail
Date

Member/Event
with key fields from other two
payment details
role

Any tips on how to make a form or query that would display all the members in a ticklist format that then feeds into the member/event table would be appreciated.

Thanks
Fred

 

[Smitty]

Why not add an "Attended" field to the Member/Event table and set it as a Yes/No data type?

 

[HiTechCoach]

This may help: Spreadsheet-like Entry Data Form Demo (Click Here)

 

[FredMcStaire]

Thank you both:

Smitty, I couldn't figure out the second step, how to display all the records in the members table while showing the yes/no field in the joining table.

HiTechCoach - it looks beautiful, and I can figure out how to use it, but the workings are a few levels above my understanding.

A colleague came up with an idea that works ( maybe not as elegantly) He suggested using a spreadsheet laid out like the members/events table and then appending it to that table at the end of the evening via linked table manager.

Thanks again for help!

 

[HiTechCoach]

Thank you both:
A colleague came up with an idea that works ( maybe not as elegantly) He suggested using a spreadsheet laid out like the members/events table and then appending it to that table at the end of the evening via linked table manager.

Thanks again for help!

If you will have a device with Excel running at the events, could you not use Access? This would eliminate the the import step.