Access 2013 - Prepopulate a subform based on criteria selected in the - Microsoft Community

we have board of directors database capture board member data, meetings attended.

the admin asst capture attendance each of specific meetings within db.  right doing within excel ss.

i have tblmtgdates contains board year, meeting type, , meeting dates associated said year/types.

the selection of dates associated type - , filtered in such way shows dates related types.

okay - part i'm with.

now part i'm having problems.

after make appropriate selections in main form, want click button has query behind query board members part of committee selected during board year selected, , prepopulate editable form have edit 2 fields "attended" and "comments" (if appl) , append information table tblattendance historical reference.

i want able pull list of attendees in future reporting, or - if need make adjustments.

i have button on main form says 'edit attendance', think might bad idea because may click add 'again', , cause duplicate information.  note - have primary keys set within tblattendance autoid, memberid, mtgtype, , mtg date fields, maybe that's not issue.

actually - think on selecting add members meeting, call should use qryattendanceexecutive if type selected executive, or qryattendancefullboard if type selected full board (these options unbound 'type' (aka cbomtgtype) field noted above.

why?  because there 3 tables related this:

1. tblmemberdata has names , other pertinent information. 
2. tblbod contains members part of full board
3. tblcommitteesserved contains members part of various committees (including executive)

so way run query related 2 types, based on cbomtgtype selection - query based on board year part of board/committee during term populate/append subform below.

the cbomtgdate auto-appended form based on above, not related 2 queries.

note:  subform called frmattendappend with source of tblattendance.

to clear, board of director members can part of various committees.  not required.  committee members part of board.

does make sense?

Office / Access / Windows other / Office 2013