Textbox

[Guest]

I have a form that contains a subform. The main form executes a parameter
query linked to the "After Update" Event. The query runs against a table
that contains order number, name, office, date, and a primary key. The
results of this query populate text boxes on the form. The subform has combo
boxes that, when selected, store their contents in the table that the sub
form is bound to. The subform is bound to a table on a SQL server and has a
parent child link by primary key to the main form. This allows for the
primary key to be stored in the table that is bound to the subform when all
is saved.

What I want to do is add a text box to the subform, use it to type free form
text, and then save the text to a table on the SQL server. I also need the
pimary key from the parent child link stored in this table as well. The
table for comments has to be different than the table that is bound to the
subform.

How might I do this?

Please let me know if you have any suggestions.

Thanks.

Mike

 

[Guest]

Use a sub form to your sub form. You will not be able to update two tables
with your query.