Update

[Mattbro]

Hi Everyone,
Access 2013, my Db has 4 tables. TbA,TbB,TbC and TbCalendar. TbA, B and C relate to tasks that need to be performed periodically. A query to each table (QryA, QryB and QryC with Left joins on the Tbl Calendar) populates 3 Forms FrmA, FrmB and FrmC respectively. Each form allows the user to record the task findings, date performed and their initials.
The Queries ask if the task has been performed within the last week/day/month. If they have, then the data will still appear on Form A, B or C. If it has not, said form will be blank. E.G for a daily task:

SELECT TbA.Temp, TbA.DateTaken, TbA.Name, TbCalendar.Date
FROM TbCalendar LEFT JOIN TbA ON TbCalendar.Date = TbA.DateTaken WHERE (((TbA.DateTaken)=Date()));

I have 3 small forms (SbA, SbB and SbC) each has 1 textbox fed off each query and are coded to have backcolour.red if null. These are on the ‘switchboard’ form so user opens up Db and sees if tasks need performing if textboxes are red. All works as required.
My problem is that when they have performed the task, the textbox stays red until closing and reopening the Db. I have played with Requery and Refresh using the ‘GetonFocus properties of the ‘subforms’;

Private Sub Form_GotFocus()
Me!Week.Requery
Me!Week.Refresh
Me!Week.Repaint
End Sub

But various combinations of the above pay no dividends. If anyone has any advice, I would be grateful.Hi Everyone,

[June7]

Just requerying or repainting the form is not enough, must set the BackColor property.

Maybe instead textbox Conditional Formatting can be applied.

[Mattbro]

Hello June7. Truth is, I started out with conditional formatting. Same problem, so moved to code. I have just knocked up a workaround in which I have moved the 3 small forms onto another form, which loads at startup in popup form along with the switchboard. It does the job, but it doesn't look as good as just having the indicators on the main switchboard page....

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[Mattbro]

DB3.zip
Hi June7-Db attached....I think....

[June7]

Options - all would use conditional formatting on textboxes that have count expressions:

1. Frm1 has RecordSource that includes counts of each task type, like:
SELECT TblCalendar2014.Date, TblCalendar2014.Week, Count(QueryDecon.NameDecontamination) AS CountOfNameDecontamination, Count(QueryFridge.NameFridge) AS CountOfNameFridge, Count(QueryAnemometer.NameAnemometer) AS CountOfNameAnemometer
FROM ((TblCalendar2014 LEFT JOIN QueryAnemometer ON TblCalendar2014.Date = QueryAnemometer.Date) LEFT JOIN QueryDecon ON TblCalendar2014.Date = QueryDecon.Date) LEFT JOIN QueryFridge ON TblCalendar2014.Date = QueryFridge.Date
WHERE (((TblCalendar2014.Day)="Monday"))
GROUP BY TblCalendar2014.Date, TblCalendar2014.Week;

2. Frm1 is unbound and textboxes on main form with DCount() expressions in ControlSource

3. Frm1 is unbound and textbox in subform footer section with Count(*) expression in ControlSource

You have dates formatted as dd/mm/yyyy which is not Access standard. I don't know how you are inputting the date values but using non-Access standard can be problematic. Review http://allenbrowne.com/ser-36.html