G
Guest
I have a main form and a subform. The main form executes a parameter query
against a table that contains order number, name, office, date, and a primary
key. 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 can't figure out is how to get a text box on the subform to allow me
to type comments in the box and save the comments to a table on the SQL
server. I also need the pimary key stored in this table as well.
Unfortunately the table for comments is different than the table that is
bound to the subform.
Please let me know if you have any suggestions.
Thanks.
Mike
against a table that contains order number, name, office, date, and a primary
key. 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 can't figure out is how to get a text box on the subform to allow me
to type comments in the box and save the comments to a table on the SQL
server. I also need the pimary key stored in this table as well.
Unfortunately the table for comments is different than the table that is
bound to the subform.
Please let me know if you have any suggestions.
Thanks.
Mike