Adding a new record to a form and subform

[felicia0202]

I have an entry form that is used to input my monthly meetings information and a subform that display a checklist that contains member names who will attend the meeting.

I created a table for the members which is called the "Attendance " table that shows all the members names. Also, I created a "Chapter Meeting" table that shows the monthly meetings and a master table called "ChpterAttendan ce" table to connect both tables.

I used some VB codes to display the checklist in the subform and it works perfectly when you search for previously recorded meetings. To search for data, I used a macro to retrieve data from the “ChpterAttendan ce” table and display that information in my entry form and subform based on my search criteria. However, to add a new record, I used a macro to open the entry form and add new information in the form. The entry form will display; however, the subform containing my checklist will not display.

Can someone please tell me what I need to do to get my add new record function to work on my database?

[NeoPa]

I'm not sure I follow the logic of your table names. If a table contains member data then why call it Attendance?

The rest was a little awkward to understand. Am I right to understand that your main form holds information for the meetings themselves and that the sub-form holds the member data for all those that attended the selected meeting from the main form?

Felicia:
The entry form will display; however, the subform containing my checklist will not display.

Can you explain what this means precisely please.