I have a Camera Check Out Log with the following fields:
-Employee
-Camera # (which is a combo box referencing a table that has the camera
numbers)
-Checked Out (yes/no)
-Checked In (yes/no)
I am trying to make it so that if for a certain camera #, if the Checked Out box is true, and the Checked In box is false, then a message box pops up saying that the camera is already checked out, or not even let them be an option in the drop down. I have tried a few different things, but can't seem to figure out how to separate the Camera # field from the data in that field, and wind up locking out the whole field. Thanks.