Displaying boxes of text and using checkboxes to select them

[Guest]

Thanks to everyone who helps support this community.

I'm creating an order management database which merges sale information to a
Sales and Purchase contract to word using Albert Kallal's great merge code.

I need a way to display a large amount of contract clauses with checkboxes
next to them, and allow the end-user to select which clauses he/she wants to
include in the contract. What would be the best way to do this and allow the
data to be merged into my existing templates?

Thank you,
Jae

 

[John Vinson]

Thanks to everyone who helps support this community.

I'm creating an order management database which merges sale information to a
Sales and Purchase contract to word using Albert Kallal's great merge code.

I need a way to display a large amount of contract clauses with checkboxes
next to them, and allow the end-user to select which clauses he/she wants to
include in the contract. What would be the best way to do this and allow the
data to be merged into my existing templates?

Thank you,
Jae

Rather than checkboxes, you might want to consider a subform. You can
base a Subform on a Query joining the table of all clauses to a
ContractClauses table; use a Left Outer Join on this query. You need
*some* field (which could be a checkbox, if you wish) in the
ContractClauses table, but entering a value in any field will create a
record in the table. Just be sure to include the ClauseID from BOTH
tables in the subform's recordsource query.


John W. Vinson[MVP]