I'm finishing a test app that I will use to teach students. My question concerns form "Assignments, mainform listbox (FILTER tbl), subform1 grid, subform2 flds"
in the attached odb file.
I select EMPLOYEE in MAINFORM. The selected EMPL_ID is saved in FILTER table.
SUBFORM holds a grid with previously assigned tasks, intended for display only.
I have a 2nd subform: NEWTASKFORM.
I enter data in NEWTASKFORM fields and press SAVE ASSIGNEMENT, then REFRESH TASK LIST to update the SUBFORM grid.
NEWTASKFORM has table ASSIGNMENTS assigned and Link Master fields: ASSIGNMENTS.EMPL_ID and FILTER.EMPL_ID
The first add works as expected.
BUT when I try to immediately add a 2nd assignment, it does an update instead. If I close and re-open the form it will save the first add but not the 2nd.
I'm sure I'm doing something silly, but I don't see it. So any help will be appreciated. But note: I'm improving!

Thanks,
Buz