Data Fields Conditionally Visible

[jereece]

I have a form frm_DataEntry. On this form I have a combo box cbo_Status. I also have other text and date fields on the form. 5 of these fields I only want visible when cbo_Status is set to "Ticket Returned". My 5 conditionally visible fields are named EmployeeName, EmployeeBadgeNo, EmployeeType, WorkGroup, and PIP. Is there a simple way to do this?

As an alternate, I have these 5 fields inside an Options Group. The Back Style of the Options Group is transparent and the 5 conditional fields are inside. If there was a way to turn the Back Style to "normal" when when cbo_Status is set to "Ticket Returned" this would also work because the background color will mask all 5 fields which would make them look invisible.

Any help or suggestions is appreciated.

Jim

 

[pbaldy]

I'd use the after update event of the combo to test the value chosen and set the visibility of the other controls as appropriate. I imagine you could set the back style too.

 

[jereece]

Can you give me some details about how to do this?

Thanks,
Jim

 

[pbaldy]

Which part are you having trouble with? You want an If/Then that tests the combo for that value. Set the visibility of those controls to True if the condition is met, False if not.