Information on a form.....

[Mark]

Now that I have a main form that is based on a table (Main_Table), and a
subform on the main form that is based on a query, I can no longer use my
update button to add a record with the data entered on the form since 2 of
the fields come from that subform.

How can I get the Main_Table to update correctly and pick up the 2 fields
from the subform? I wanted to use a make table query to push the form data
to a temp table, then have that temp table append to the Main_Table, but I
can't see how to create a table from a form.

Thanks in advance for the help.....

 

[Jeff Boyce]

Mark

If I'm understanding correctly, your main form holds controls connected to
fields that would "belong" on your subform.

Since everything starts with the data in Access, please describe your
underlying tables. For instance, you mention a query that serves as the
source for your subform. But a query is useless unless it is based on data
from a table (or from another query, ... eventually based on a table).

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mark]

Mark

If I'm understanding correctly, your main form holds controls connected to
fields that would "belong" on your subform.

Since everything starts with the data in Access, please describe your
underlying tables. For instance, you mention a query that serves as the
source for your subform. But a query is useless unless it is based on data
from a table (or from another query, ... eventually based on a table).

Let me know if more info is needed..... Thanks....

 

[Jeff Boyce]

Mark

So I'm still confused...

If your main form is based on data in your main table, and your subform is
based on a query that is based on another table (I missed that in your
original post), then what business need are you satisfying by writing all
the data from both the main form (table) and subform (table) to a third
table?

The usual way in Access to handle creating a report showing both (if that is
what you are doing) is to use a query that joins the two tables together.

Sorry, but I still need more info to offer specific suggestions... For
example, I still have no idea what kinds of data you've stored in your two
tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP