how to do an agreement form with custom fields???

[miscluce]

I have a project that I am doing with VBA in Access 2007. One of my tasks is to have a contract/agreement form which is mostly standard information except for the name of the customer it is going to be print out for.

Does anybody know how can I link the contract to a specified text control(that contains customer name) on an access form that will fill in the appropriate spot in the contract? I have no idea where to start. can someone share some ideas?

 

[randy700]

Information that is common to all contracts could be stored in a separate table, using memo fields. Use a dlookup to display them on the form. Design the form to leave appropriate room for text boxes used to hold specific customer data. Bind the form to the customer table. Use a report, based on the same query/table to provide printed copies for your customer.


Randy

 

[miscluce]

Randy700,

"Information that is common to all contracts could be stored in a separate table, using memo fields." How is this possible I will have a legal document with about 5,000 words in it.

The plan is to have a form with the custommer details that is being populated from an sql server and whatever record the form is currently showing in the text controls I want to link it to the contract to fill in the appropriate fields for print out. Sort of the same principe as a mail merge in MS word.

 

[JoeAtWork]

I'm thinking the following:

1. Create a Customers table with all the required fields
2. Create a form that is bound to the Customers table
3. Create report with all the common text in labels or textboxes
4. Bind the report to the Customers table
5. Sprinkled throughout the report are the fields for the customer info
6. On the form, have a button that opens the report, filtered by the customer ID

 

[miscluce]

I think I may have it. This may work??????

I'm thinking the following:

1. Create a Contract and customer table with all the required fields
2. create a customer form
3. Create report with all the common text in labels or textboxes from the contract table and have a txtbox called customer name from teh customer table that is absolute positioned in the appropriate spot
4. Bind the report to the Customers table and contract table
5. Sprinkled throughout the report are the field for the customer name and textbox with contract info.
6. On the form, have a button that opens the report, filtered by the customer ID