I am using a form to enter new programs. Programs are targeted at specific members. To facilitate entry, I would like the subform to display a list of all available members and a check box (default yes). The user can then uncheck any members that are not targeted by the program.
My problem is the following: I have the query which creates the list, but it does not automatically populate the ProgramID and MemberID fields in the Participants table, nor does it display subform like it does in datasheet view.
Any ideas where I should start, I need to stop spinning my wheels

exhibit:


Program ID
Program Name

Program Description

subform
Member1 v
Member2 v
Member3 v


Thanks for the help.

Welcome To Utter Access Forums! -o!

In your subform "fsub_EditPrograms" change the MemberID control to a combo box based on tblMembers. The combo box should be bound to MemberID and the bound column of the combo box should be 1 and the first column in the combo box should be MemberID.

Selecting a member from the combo box will automatically update the ProgramID and the MemberID will be saved in the appropriate table...

Also, "fsub_EditPrograms" should be bound to table "tbl_Participants". And I am not sure why you have the "ParticipationStatus" field because if the member is selected he/she is a part of the program and if they are not in the table then they are not part of the program...you would not select members who do on participate...

hth,
Jack