First, thanks for the wonderful help I have received from the members of this forum.
Here my problem.
I have never worked with subforms before, and now I am running into a wall. I need help setting up a subform to diplay the data from a table linked in a many to many relationship.
My main form has been passed a Prog_Name and cooresponding Program_ID. On that main form I also have a combo box allowing a user to select a Requirement/Require_ID. I would like my subform to show the started and completed data for each Program_ID/Require_ID combination.
I have been able to display the two ID's on the subform, but when a user changes the Require_ID from the combo box, the subform does not add a record for the new combination, it just updates the Require_ID field and leaves the rest of the data the same. No new record.
You didn't say how the record info was being displayed. I think that makes a difference. If you use text boxes, make sure you created the combo to "search for a record", then you won't need additional coding; if your using a list box, then you'll need a little code in the AfterUpdate event of the combo box.