- Joined
- Aug 11, 2009
- Messages
- 11
- Reaction score
- 0
I have a problem that may be an easy fix and I am not seeing it.
I have a database that tracks LOT #'s these Lot #'s can only be added to the database from one department, I enter in the Lot and if it is not in the database it will create it and bring me to a form to fill out, I have another department that enters in their information on a different form. If the other department enters in the lot number on the main form and clicks their respective department and that lot number they had entered is not in the database yet their form displays but only the header/footer shows. What I want to do is if the Lot # is not in the database to display a message to the user. How can I perform this?
Any help would be great.
I have a database that tracks LOT #'s these Lot #'s can only be added to the database from one department, I enter in the Lot and if it is not in the database it will create it and bring me to a form to fill out, I have another department that enters in their information on a different form. If the other department enters in the lot number on the main form and clicks their respective department and that lot number they had entered is not in the database yet their form displays but only the header/footer shows. What I want to do is if the Lot # is not in the database to display a message to the user. How can I perform this?
Any help would be great.