Hi again
I have solved this problem! I declare a temporary variable (TempVars
("stLabel").Value = "M1A1 Fail") when selecting the Module in step 1 and then
use it as control source for a control on the label.
Many thanks for your help - your original comment about changing the
"captions value" made me start thinking!
Many thanks
Kary
kary wrote:
1. I have a form with command buttons to select the item required eg Module
1, Module 2, etc.
2. My query calculates the Final mark for each Module of a course. In
addition it has a field for each Module with an IIF statement which marks the
students who fail by putting the text "Fail Modx". (Is there a better way to
do this as my sql command which shows in Sql View is long and cumbersome; I
know I don't really need to look at it but ..)
3. Then I need to print labels for all students who have failed. I would
like to have just 1 report printing these labels depending on which Module is
requested in step 1. The report prints fine with the OpenReport command
using a where condition. .
However, the Module they have failed may be in one of 6 fields of the query
so all 6 fields need to be added to the report which fills up the report
label and makes it messy.
SO, I'd like the control/field for "Fail Modx" to be invisible and then when
the selection is made in Step 1, for that modules control/field to become
visible.
Hope this makes sense!
Regards
Kary
Where are you (?proposing to be?) selecting this option?
[quoted text clipped - 11 lines]
Thank you
Kary
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201004/1