I'm working with SQL Server Express 2005 with an Access 2007 .adp front end.

I have an existing database that stores 'billables' in various tables:

tbl_Expenses
tbl_Disbursements
tbl_Hours

Each of these tables is related to the tbl_Projects table (1 project can have many expenses etc...)

We would like to add another table to store "canned" explanations of work done:

tbl_CannedStatements (statement_id as int (identity), the_Statement as varchar(8000))

So far so good... what I need to do is create a form that will allow me to enter the Project_ID and have all of the:
Expenses,Disbursements,Hours for that particular Project (THAT HAVE NOT BEEN USED IN AN INVOICE YET) appear in the form, as well as have a check box beside each which determines whether or not to include them in this particular invoice.
Also - I would like to have a blank text box which, when I click on one of the 'canned' statements, copies the canned statement and pastes into the text box, ready for addition and / or editing.

I have tried a couple of times but I'm having a hard time referencing the record from one Subform to the main form.
I'm trying something like this:

frm_NewInvoice
SubForm_CannedStatements



This results in undefined object or something similar....
So my questions are:
How can I reference values from 1 form and use them in another, container form?
How do I add checkboxes for the individual entries for expenses,disbursements, and hours, then TEST to see if they're selected or not before I create the new invoice.
I will also need to SET the "usedInInvoice" value to True if they're selected....

Any suggestions are welcome!
Thanks

This post has been edited by Nolan: 9 Sep, 2008 - 12:15 PM

Did you figure this one out Nolan?