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
Thanks for the help.