I have a continuous form (frmLiveProjects) – filtered by a query (qryClientProjectsFrm) from the main form (frmProjects). On frmProjects there is an option group (FrameProjectStatus) which has three alternate options.
I would like to change the background colour of the fields for the various records on frmLiveProjects depending on which option is checked on the option group.
If none of the three options are checked then I would like to background colour to remain white.
Any help would be very gratefully received.
Cheers
Rob
I would like to change the background colour of the fields for the various records on frmLiveProjects depending on which option is checked on the option group.
If none of the three options are checked then I would like to background colour to remain white.
Any help would be very gratefully received.
Cheers
Rob