Can anyone tell if you can link to tables together without having to write a SQL statment, without using a wizard? The reason I'm not using a wizard is because I already have the form created.

Steve

Subforms can be linked without using a wizard if that is what you mean.

Your not beeing verry specific....

Regards

Sorry, not being more specific. What else would you need to know to better understand what I'm asking?

I created a form that feed table 1. On this same form I want it now to write to a NEW table without changing any of the fields. I will be adding the NEW fields that are needed to write to the NEW table. I hope this helps understand what I'm asking??

Still sounds like a subform to me...

You know how to create/link a subform? If you dont try making a copy of your form and try using the subform wizard (it doesnt hurt your main form, but i you are unsure of the prosses its allways best to make a copy first to try it out on)

Regards