Hello all,
Okay, lets see if I can explain this with as little confusion as possible . . .
I wrote a query that is asking for you to enter the ID number of the table information you wish to review. So when the query starts It will ask "Enter ID Number" I would then like the database to goto that form that was designed showing all the information related to the ID number entered.
(Open Work Orders form)
If the task has already been completed, based on a check box related to the ID number, being false then I would like a form that opens and says "The task has already been completed, would you still like to review or return to main form?" With a "Yes" or "Return to main" command button.
Can someone help?
Mike