I have a database that contains equipment serial numbers. I have a switchboard set up to run the database. One option is to search by serial
number. When I enter an existing number, everything works fine. I have a button on the form to return to the switchboard.
The problem is if I enter a serial number that is NOT in the database. I end up with a blank page that has no buttons.
I want to either have the buttons show up or, preferably, have a message pop up notifying the user that there is no records found and then return to the switchboard.
I searched the web and found some information about VBA programs to do this but they were so far over my head that I could not even figure out what to change to make it work.
I am thinking there is some type of macro I could use along with an form event (On Open?) to do this.
Any help appreciated.
number. When I enter an existing number, everything works fine. I have a button on the form to return to the switchboard.
The problem is if I enter a serial number that is NOT in the database. I end up with a blank page that has no buttons.
I want to either have the buttons show up or, preferably, have a message pop up notifying the user that there is no records found and then return to the switchboard.
I searched the web and found some information about VBA programs to do this but they were so far over my head that I could not even figure out what to change to make it work.
I am thinking there is some type of macro I could use along with an form event (On Open?) to do this.
Any help appreciated.