Form help

[GRM-kenyette]

I have a form with a combobox when CHOOSE A SPECIFIC NUMBER 008, 3 new boxes become visible, the problem is when I move to a new record I want the boxes to to become invisible again
I have in form load for them all to invisible so they start out invisible but if that number is choosen then they become visible and stays for all records after or before that record .

 

[RichO]

Try using the form's On Current event (instead of the On Load event) to make them non-visible.

 

[GRM-kenyette]

thanks

thanks worked like a charm, now im wondering if on the same form, i have a subform and i want all info to be in uppercase dont no where to use the UCASE FUNCTION FOR THIS