Creating a Form linked to 2 tables

[Stevefsn]

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

 

[namliam]

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

Your not beeing verry specific....

Regards

 

[Stevefsn]

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??

 

[namliam]

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