June7,
I figured another way,, plus not to use update, vice Append to add new data to a field in a table.
I am also using a temp table to store data from the form and using that to append the original table.
Now I am confusing myself, I have the following append queries using the same source field to field 1 or field 2 depending on the check boxes.
Code:
INSERT INTO tblData ( Ex1 )SELECT Unit.Unit
FROM Unit
WHERE (((Unit.Unit)=IIf([Unit].[Check1]=True,[Unit].[Unit])));
Code:
INSERT INTO tblData ( Ex2 )SELECT Unit.Unit
FROM Unit
WHERE (((Unit.Unit)=IIf([Unit].[Check2]=True,[Unit].[Unit])));
How can I combine these? I want the unit to be on the same line if both check boxes are true.
Thanks