I have a database that serves as a visitor check in and check out with ID badges. I have two tables one with visitor info with an visitor ID number that auto generates. The other is an event table to enter information when a visitor comes in. I have a lookup query to auto fill in the fields related to the visitor info table, after entering just the visitor ID number.
What I want to do is, if some one enters a visitor ID number that does not exist in the system a mesg box will display stating the error then open a second form to enter the visitor info, thus generating a ID number for the visitor.
I have some knowledge of VB in access but I’m un-sure on how to go about writing it up. Any help would be greatly appreciated.