I have a database that tracks equipment status in real time. The db is setup for the user to enter a name of a tool and the status. There are 5 forms of status [down] [umip] [umcomp] [umqual] [up] in that order.

The status is activated through a query with the [Enter Status] critera and this appends a table. I want to restrict the user from being able to skip the status order.

Tool is "down" and the user enters status as "umcomp". I want a message to display and say tool must be in "umip" to complete this transaction.

Any Ideas?