Hi everyone....Happy Holidays!
I am using Access 2007 and have a database that is working fine but would like to install a control-check on an input form.
At the beginning of this form the user must enter a job identifier (JobID). However, this value may be closed out and therefore no further input should be made against this particular JobID.
I have developed a query that produces the closed indicator for any given JobID but I do not know how to incorporate the query results within a macro and put this into the control/field when the user inputs a certain JobID value and tests if it is closed out.
I would like a message box to pop up, after they input a JobID, telling them that this particular JobID is closed. I want to give them the option to continue with a different JobID value or the option to abort the input and exit the input form.
I am a novice at VBA but am willing to try it if someone will supply me with the code, and some instructions on 'installing/implementing' it.
Any help would be greatly appreciated it.
I am using Access 2007 and have a database that is working fine but would like to install a control-check on an input form.
At the beginning of this form the user must enter a job identifier (JobID). However, this value may be closed out and therefore no further input should be made against this particular JobID.
I have developed a query that produces the closed indicator for any given JobID but I do not know how to incorporate the query results within a macro and put this into the control/field when the user inputs a certain JobID value and tests if it is closed out.
I would like a message box to pop up, after they input a JobID, telling them that this particular JobID is closed. I want to give them the option to continue with a different JobID value or the option to abort the input and exit the input form.
I am a novice at VBA but am willing to try it if someone will supply me with the code, and some instructions on 'installing/implementing' it.
Any help would be greatly appreciated it.
