Hi Guys,
This is my first post on what seems to be a popular and informative site.
I have a database which contains Maintenance Records for vehicles and machinery. One of the tables contains details of service information. When the database opens I have a piece of code which checks this table for any incomplete or overdue services and if necessary displays a pop up window asking if the user wishes to see these. My problems are if I click No the default switchboard which I am left with which contains 7 buttons has one button which is disabled this points to a second switchboard which will display reports, if I click Yes all buttons work. If there are no records to display the switchboard contains this disabled button
Thanks in advance for your help
This is my first post on what seems to be a popular and informative site.
I have a database which contains Maintenance Records for vehicles and machinery. One of the tables contains details of service information. When the database opens I have a piece of code which checks this table for any incomplete or overdue services and if necessary displays a pop up window asking if the user wishes to see these. My problems are if I click No the default switchboard which I am left with which contains 7 buttons has one button which is disabled this points to a second switchboard which will display reports, if I click Yes all buttons work. If there are no records to display the switchboard contains this disabled button

Thanks in advance for your help