I have 2 tables, Books and Checkouts
Books has name, id and status
Checkouts has id, startdate and returndate
If the return date of the book is lesser than date(), it should change the status to overdue. The following code is what I have but it doesnt work because I dont know how to get the returndate from my Checkouts table
Could someone help
dbCW.Execute ("UPDATE Books set [status]= 'OVERDUE' where [returndate] <#" & Date & "#")
I created a small sample that I think does what you're asking for. If not let me know and will go from there. Just open the form, place a Date in the DateDue box, then go ahead enter a Book Title, CheckedOut date. Then as soon as you enter the returned date, if it is Past the due date.....you'll see.
I don't think that was what he was looking for. Particularly because he submitted his question with an update query. That to me means he wants to change the data in the table, not pop up some message when you change a date.
You are so right, I kinda overlooked that part. That happens when trying to help out and working hard at the same time. Glad you were able to help him out. And thanks for pointing that out to me. Just need to slow the eyes down a bit