Hi guys,
I have a continuous form and one field is Day / Night, where a 'D' or 'N' is contained to represent each.
Is it possible to write code for the 'on current' of the form to ensure a box contained within the specific record is one colour for those records with 'D' and another for those with 'N'?
I used for...each...ne xt statement from the help and adapted it to suit my form, but it changed the colour of ALL of the boxes depending on which record was highlighted???
Hope you can help, OllyJ
I have a continuous form and one field is Day / Night, where a 'D' or 'N' is contained to represent each.
Is it possible to write code for the 'on current' of the form to ensure a box contained within the specific record is one colour for those records with 'D' and another for those with 'N'?
I used for...each...ne xt statement from the help and adapted it to suit my form, but it changed the colour of ALL of the boxes depending on which record was highlighted???
Hope you can help, OllyJ
Comment