I know nothing about VBA.. but i use access regularly. (my VBA class is soon thank god)
here is my issue..
I have a report and a form that ask for "Lot_Number" when they are launched.
once the user enters that "Lot_Number" it launches the approite report or form.
If the user enters an incorrect lot number it still launches the form to the first "lot_number" record.
I want to return an error if the lot number is not in the system when they input it.
This is all i have so far..
Private Sub Form_Load()