Problems with Form not connecting to 2 tables.

[Alphix]

Long story:

As I am developing this database I found out I need to delete the original table connected to the form.
I need to create 2 tables for one form.
Well I deleted the table and created 2 separate tables.



My INSERT INTO code does not connect to my desired tables.
I called out the table and I believe the code is correct.

Are their other reasons why my original form does not connect to my new tables?

It is a pain to have to created an entire new Form and Table every time I make a change.

[JeffChr]

Without more details that is a difficult question to answer. Probably the best way to connect two tables to one form is to use a query. If you use a select query, you will need a field common to both tables to define a relationship.

[Alphix]

I have a user interface which has two sets of data to be entered through a Form.

[June7]

Normally, one form is used to enter/edit data to one table. If you split a table into 2, possibly you should now use a form/subform arrangement.