Update new table from form and subform

[REDaughdril]

I have a table called "tblMissions" and a table named "tblUnits"

I have a form called frmMissions (to enter the different missions) and a subform called (frmUnits) for the unassigned units to choose from.

I have button on the frmUnits subform to choose the unit which enters the mission number and unit number in a new table called "tblUnitsAssigned".

That all works however when I pick another unit, it updates the data in "Unit Assigned" but will not add a new records (which I need)

I have another subform (frmUnitAssigned) that shows the units assigned.

So how do I assign multi units to that mission.

I know that when you reply, it will make me feel show stupid because I will say, I knew that.

Thanks for the help.

 

[ajetrumpet]

I have button on the frmUnits subform to choose the unit which enters the mission number and unit number in a new table called "tblUnitsAssigned".

That all works however when I pick another unit, it updates the data in "Unit Assigned" but will not add a new records (which I need)Thanks for the help.

I guess I'll take the blame for making someone feel stupid here....

Sounds like you wrote an UPDATE query instead of an APPEND query, which is what you need to get the job done....but I guess you knew that, right??