Look at at creating an after update event when you close the form. If the checkbox has been checked, then with a little vba you can add records. Or you can use the after update on the checkbox and add them as the box is checked.
Come back if you need more help

John

Hi Deborah
I don't know your level of expertise, so I made a quick prototype for you. If you want it as a start, let me know in the post and I will give you a link for the file. John

Deborah this is yet another case of why Richard advises that you take his classes in order and not skip around.

You need to know Relationships as well as Append Query.
Also how to have a Form with a Subform and create buttons to perform actions.
There is a lot to know here I understand.  

There is an example of what you are describing, almost to the letter (except using student attendance as the example), beginning  in Lesson 5 of Access Expert 14 and continuing in  Access Expert 15

This is only one way of handling this.  The other way would be to set your tables up such that when you add the attendee onto the subform they have attended. No need to have a check off.

So...  Where I'm headed with this is, is this a 'one off' type of thing as far as the event goes or is it something like a weekly of monthly club meeting?  I would handle it differently if it were one verses the other.  Another factor that I would consider is the number of people attending.  Again different if there is 15 to 20 attendees vs 300.

Thank you for the suggestions. To Scott, I have taken several classes in Access. However, since I don't use it everyday I don't remember everything.   The relationships are right. I can get it done with a make table query using  "true" criteria and then append new table to the attendance table. Then delete the contents of the new table. The forms I worked out with new meeting as parent on single form with attendees last name, first name & check box as a drop down. There are other ways I am sure.  I was looking for some less convoluted ideas.  I will look at the suggested chapters. Thank you.

Deborah it sounds like you are on the right path.  I understand about not working with Access on a daily basis.  The beauty of the learning path is you don't have to know everything there is to know about Access to build some really cool and useful databases.
Even better is you don't have to be a programmer if you don't want to be.

Feel free to post some screen shots of your tables and forms.  We can make suggestions either for videos or directly about your specific set up.  Of course use fake data or blur out personal info as needed.

John Davy, I would really love to see your prototype!!  I love the idea of, you can use the after update on the checkbox and add them as the box is checked!!  I am not sure how you get there.  I am building this for a non profit dog club of about 20 members, for my own use to keep things organized.  I have not played in Access for a few years.  I enjoy messing around with a copy of what I have that is working while I  expand on what it can do.  Today I think I will be working on an agenda form that can be entered, saved as, printed & then that agenda form saved as for that meeting date is further expanded to a Minutes form adding to what was on the agenda form creating a save as, meeting date, minutes form to be saved as, printed or emailed.  Also, a meeting sign in sheet based on the members last name, first name query in a report that can be printed out circulated at meeting, signed by attendees and later used to enter Meeting Attendance form (as was my original question).  I have finally figured out how to do the "get email addresses" with a select box next to name to create a list of emails, with a comma between them to do a quick copy and past into an outgoing mail. The dues portion is not problem because it is only $10 annually pretty simple.  I can not for the life of me understand why there is not such Club template available to manage a small not for profit club.  I am in two of them (a rural cemetery mgt and a Dog Club) for both everything is done with paper or excel.  They are messy.  Clubs really need a relational db looking at Members, Events, Meetings, Agenda, Minutes, Attendance, Dues, Expenses, Email, Snail Mail, Forms or Document storage (ie. blank membership application, blank correspondence letterhead, Newsletter as Word attachment maybe some other stuff.)  I am still sorting it out.

Also, Income should be another thing I failed to mention.  Thanks all.

Good news!  There is a TechHelp for you.  (Richard pretty much has a video for everything it seems.  You just have to know where to look LOL.)

Check out the Checklists

Membership Database
Since you are a Gold member you get to watch the Gold Extended cut as well as download Richard's db to play with or use as a starting point.

While you are looking about check out the Event Enrollment video as well.
Between the two there are TONS of Lego pieces that you can put together to do some really fun stuff!

Hi Deborah
Scott's recommendations are excellent and I highly recommend watching and studying Richard's videos. If you still want the little prototype, then send my your email address to [email protected] and I will give you a link to download it. John

Scott, That Checklists lesson is really perfect to adapt to attendance!!  I will use that.  The membership database is OK and I have seen that.  I am about to look into the Event Enrollment video.  There is a struggle to locate on this site tips for how I get to where I want to go and how to get the db to do what I need the db to do.  There are so many ways to go.  I appreciate the help and direction.

The Event enrollment video is also perfect!!  Thanks again for the direction.  This has been very helpful!!

Deborah if you are searching  for something  I often go right to the Microsoft Access Outlines (Index).
Using Ctrl-F - Find - you can put in key words and phrases that you are looking for.  The Search at the menu line will work too but sometimes I just want the videos and courses.

I thought of another one for you too.  Richard just recently did a series on Association.
There was 10 or so videos covering "associations, groups, schools, memberships, churches, temples, donations, table design, form layout"