Insert into table values from main form and subform (1 Viewer)

Sam,
If you are running append queries to append data from unbound forms, you are not following any advice that I gave you and you are not taking advantage of any of Access' RAD capabilities. So, you end up with all the bad things about Access with none of the benefits.

I'll bow out now. Good luck.

Hi Pat Hartman,

Thanks for the advice.