Color coded forms

  • Thread starter Thread starter doyewumi
  • Start date Start date
D

doyewumi

the form am working on. it has several tabs headings
relating to the same person as you move along.
To save time clicking on every tab to find out if there is
any data. Can I have the top tab color codes, e.g say red
when it has data. so the user knows which tabs to click on
when the form loads.
Instead of clicking on all the available tabs.
Pls advice

Many thanks
Dapo
 
Hi Dapo:

What you need to do is to place a conditional colored bitmap for the tabs-

Dim rst as recordset
Set rst = Forms![YourFocusForm].RecordsetClone
rst.movefirst
rst.movelast
If rst.recordcount > 0 Then
page1.picture = "C:\RedBackground.bmp"
page2.picture = "C:\BlueBackground.bmp"
page3.picture = "C:\BlueBackground.bmp"
Else
page2.picture = "C:\RedBackground.bmp"
page1.picture = "C:\BlueBackground.bmp"
page3.picture = "C:\BlueBackground.bmp"
End If
rst.Close

That should work for you... at least theoretically. Let us know if it works!

Regards,
Al
 
Back
Top