You kind of lost me. I tried typing in the Cancel = Me![PROCESS] = "Canned"
assuming the [ControlName] is the field called Process. It comes back and
says it can't find the field. Not sure what you mean by "where the (x) is
the...." The Process Group Footer shows as GroupFooter0. Event procedures
are new to me.
fredg said:
On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote:
I have three footers in my report:
COM_VAD
PROCESS
LABEL_TYPE
PROCESS is either canned or frozen. COM_VAD is either commodity or
value-added. Frozen can be either commodity or value-added; canned will only
be commodity. How can I suppress the PROCESS footer if the process is canned?
Thank you in advance!
Karen
Code the Process Footer Format event:
Cancel = Me![ControlName] = "Canned"
Where the (X) is the Group header's section number, i.e. the Report
Header is section(1), the PageFooter is section(4), etc.
1) [Process] is the name of your table field that stores "Canned" or
"SomeOtherValue"
The name of the control in the report may or may not be "Process".
You need to refer the actual name of the control in the Process Group
Header that displays the value "Canned". Look at it's property sheet
on the Other tab.
2) Is [Process] a text datatype field, or is it a LookUp field.
Look in table design view. If the datatype of the Process field is
Text, fine. If, however, it is Number, look at the LookUp tab in the
lower panel. It will say Combo Box.
You are using that infamous lookup field, which stores a Number value
but displays text.
You can most likely substitute the "Canned" number value:
Cancel = Me.[Process] = 3
Where 3 is whatever the actual value is. You'll need to look it up in
whatever table you are storing the Process values.
Once again, make sure that [Process] is the actual name of the
control.
