T
Terry Best via AccessMonster.com
My contracts are the same for all customers, however I may
include or exclude some items in the contract based on the scope of work.
The problem I have is creating the report from my form with checkboxes on it.
Based on the checkboxes, I want to add specific blocks of text from a table
into a report.
I can't figure out how to get the "IF this checkbox is true THEN add Contents
of
[text], to the Report, Else don't add it to the report.
The form just provides "ticklers" so that I don't forget to add something in
my contract.
Checkboxes like this:
[]CONCRETE SCOPE INCLUSIONS:
[]a. Pouring of Vertical Concrete
[]b. Grinding of ceiling soffits.
[]CONCRETE SCOPE EXCLUSIONS:
[]a. Pouring of Foundations or Grade Beams
[]b. Point, Patch or Rubbing of Concrete
[]FORMWORK
[]a. etc...
[]b. etc...
[]REBAR
[]a. etc...
[]b. etc...
Each heading is on a diffetent tab of the form, but all checkbox items are
from the same table [contracts].
I only show an "a" & "b" under the heading, but there could be up to ten or
fifteen sub items for each heading.
Can someone show me how to do this? Or even provide an existing example
database that may be similar in function. I could hack out what I need. I
have created some databases in the past that have cut and pasted VBA in
them and I am getting better at writing my own, however I am Just learning
this VBA wizardry so please, be easy on me.
You could get over my head pretty quick.
Thanks In Advance
Terry Best
include or exclude some items in the contract based on the scope of work.
The problem I have is creating the report from my form with checkboxes on it.
Based on the checkboxes, I want to add specific blocks of text from a table
into a report.
I can't figure out how to get the "IF this checkbox is true THEN add Contents
of
The form just provides "ticklers" so that I don't forget to add something in
my contract.
Checkboxes like this:
[]CONCRETE SCOPE INCLUSIONS:
[]a. Pouring of Vertical Concrete
[]b. Grinding of ceiling soffits.
[]CONCRETE SCOPE EXCLUSIONS:
[]a. Pouring of Foundations or Grade Beams
[]b. Point, Patch or Rubbing of Concrete
[]FORMWORK
[]a. etc...
[]b. etc...
[]REBAR
[]a. etc...
[]b. etc...
Each heading is on a diffetent tab of the form, but all checkbox items are
from the same table [contracts].
I only show an "a" & "b" under the heading, but there could be up to ten or
fifteen sub items for each heading.
Can someone show me how to do this? Or even provide an existing example
database that may be similar in function. I could hack out what I need. I
have created some databases in the past that have cut and pasted VBA in
them and I am getting better at writing my own, however I am Just learning
this VBA wizardry so please, be easy on me.
You could get over my head pretty quick.
Thanks In Advance
Terry Best