Hi everyone, hope this makes sense if not someone point me in the right direction please.
I have a form for vehicle maintenance. I have 3 conditional formats to show red for out of inspection, yellow for those coming up for inspection and green for ok, that works fine. the form is in continuous form view, so I have a textbox that chnages colour depending on a week number if it is in date or not, What I would like to do is filter all the reds or all the yellows or all the greens from 3 command buttons, does that make sense. I have succesfully been able to filter categories, location and status without a problem but can't seem to transfer the conditional criteri to a command button to filter out the inspection criteria on the form can you help please.
I have a form for vehicle maintenance. I have 3 conditional formats to show red for out of inspection, yellow for those coming up for inspection and green for ok, that works fine. the form is in continuous form view, so I have a textbox that chnages colour depending on a week number if it is in date or not, What I would like to do is filter all the reds or all the yellows or all the greens from 3 command buttons, does that make sense. I have succesfully been able to filter categories, location and status without a problem but can't seem to transfer the conditional criteri to a command button to filter out the inspection criteria on the form can you help please.
