I have a form to check out books data source is a query made up of 4 tables the code to prevent selecting a book already signed out is:
Private Sub BookName_ID_BeforeUpdate(Cancel As Integer)
If Forms!tblLibrary1!CheckedOut = True Then
MsgBox "This book is checked Out Select another"
End If
End Sub
and it works great. The problem is when I delete the record of a book that is checked out the record from the query and tables are deleted, but the yes/no field in the books table stays checked.
Even though the record is deleted when I select a book that was checked out in the deleted record the message says the book is checked out until I go and uncheck the field in the books table.
Any Ideas!