Problem adding record with data from form

[gamesman]

I have an access form that gathers data from multiple tables and funtions. Each control is unbound. I want to use a command button to then store the values into a table. (If the controls are bound then I get validation errors during the loading of the form as the control values are not setting to the fields validation requirements.)

I want to use a command button to add the values in the controls into a single table. Since the controls are unbound, I can't just use the acMenuEdit, AcSave route. I've tried the DoCmd.RunQuery (Insert Into table (field,,,) values (me.control1, me.control2,,,) and that didn't work.

I'm trying to stay away from ADO/DAO due to network environment restrictions.

I would appreciate any suggestions.