Not sure if this would qualify as a Query or Form question, but here goes...
I have a form called Menu with a button called Followup.
Button Followup opens a form called Followup which retrieves date from a query called, wait for it... Followup
What I would like to happen:
When form Menu loads I would like it to run query Followup (invisible to user) and return a record count
If the record count is > 1 then modify the property of button Followup on the form Menu (make it red, bold, whatever)
Simply put I want the user to be able to see if any records require Followup without having to click the button
I've googled to no avail, any assistance would be greatly appreciated