Prev: Page Count Error
Next: filling a field in a continuous form with a field from a table
From: Danny on 29 Mar 2010 19:26
i have a combo box in a form to select 1 of 5 values and i setup list so each selection has a number value ie, 1. table 2.dessert etc. i have check boxes on the report that have to be checked based on the value selected on the form. i have to show all check boxes on the report but only check the box for the value choose in fhe form. i have tried to do conditional statement on the report and check for numeric value and then set check value to true based on that but haven't had any luck. any help greatly appreciated.


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Circular Progress Indicator
http://www.eggheadcafe.com/tutorials/aspnet/4d89b4cb-ba59-4362-ab0a-cc047643fd42/wpf-circular-progress-ind.aspx
From: Marshall Barton on 30 Mar 2010 09:43
Danny Jackson wrote:

>i have a combo box in a form to select 1 of 5 values
>and i setup list so each selection has a number value
>ie, 1. table 2.dessert etc. i have check boxes on the
>report that have to be checked based on the value
>selected on the form. i have to show all check boxes
>on the report but only check the box for the value
>choose in fhe form. i have tried to do conditional
>statement on the report and check for numeric value
>and then set check value to true based on that but
>haven't had any luck.
>

I think it would probably be easiest to to use a bound
Option Group on the report, Set each check box's Option
Value property to the corresponding combo box number value.

If you have a problem with that, post back with more
details.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Page Count Error
Next: filling a field in a continuous form with a field from a table