C
Chris
I have a form that the user enters data into. 2 of the
fields are txtQuestionNumber and txtPlant.
What I want to do is after the user selects a question
number from txtQuestionNumber and plant from txtPlant run
code that goes to the table my information is stored in,
check to see if the question and plant are already entered
and if the criteria matches have a message come up that
says "You have already enter that question number for this
facility, do you want to continue or start with a new
record?" giving the user the opportunity to keep the
record they are typing or starting a new record. I want
to give the user the opportunity to save more than 2 of
the same questions for a particular plant.
fields are txtQuestionNumber and txtPlant.
What I want to do is after the user selects a question
number from txtQuestionNumber and plant from txtPlant run
code that goes to the table my information is stored in,
check to see if the question and plant are already entered
and if the criteria matches have a message come up that
says "You have already enter that question number for this
facility, do you want to continue or start with a new
record?" giving the user the opportunity to keep the
record they are typing or starting a new record. I want
to give the user the opportunity to save more than 2 of
the same questions for a particular plant.