I have a form that is used to enter some data.
The record source is a query based on one table.
The fields on the form is: ServiceID, SerialNbr, CartStatus, CartDate, CartEvent, CartRepairType, Remarks
Ok here is what i'm looking to do.
When the user enters a number in the SerialNbr field I need to verify if that number is "Available" . btw The CartStatus field is a combo box that has the values of "InService, Available, Unknown, Other"
I guess Basically what I'm trying to say is........
If the SerialNbr that is entered does not have a CartStatus of "Available", I need a message to say "This SerialNbr is not Available".
How do I do this with code?
The record source is a query based on one table.
The fields on the form is: ServiceID, SerialNbr, CartStatus, CartDate, CartEvent, CartRepairType, Remarks
Ok here is what i'm looking to do.
When the user enters a number in the SerialNbr field I need to verify if that number is "Available" . btw The CartStatus field is a combo box that has the values of "InService, Available, Unknown, Other"
I guess Basically what I'm trying to say is........
If the SerialNbr that is entered does not have a CartStatus of "Available", I need a message to say "This SerialNbr is not Available".
How do I do this with code?
Last edited:
