Form Error

[Mike3411]

I have a form that is supposed to allow a user to select from a list, then click a button to change a value.
First, I have a combo box with:

Control source: bookList_bookTitle
Row source: SELECT bookList.bookTitle FROM bookList WHERE (((bookList.checkedOut)=True)) ORDER BY bookList.bookTitle;

then, I have a button with the script:

Private Sub saveRecord_Click()
Me.checkedOut = False


I want it to change the "checkedOut" field of the appropriate bookList item. why isn't this working? how can i fix it?
thanks,
Mike

 

[WayneRyan]

Mike,

We have two problems here:

1) You could use the AfterUpdate event of the combo
to: Me.CheckedOut = True

2) Don't store that data! If the BookTitle has an
entry, then it is checked out!

Wayne