Unanswered: Im stuck with a listbox and query - Help needed!
I am creating a video rental database.
On my main form I can select a certain user from a row on a listbox which loads a second form.
The second form also has a listbox (lstuserbookings) which displays all the particular bookings of videos that that user has made. It shows videoID, datebookedout, dateduetreturn, userID etc. When I select a row I have textboxes which show the records which relate to the fields.
On this second form I want to enter a "date video returned" date into a textbox - and have it saved to the bookings table and thus show up in the row on the listbox under the heading "Date Returned". I have the empty field in the corresponding table (tblbookings) and in the query (qryuserbookings) for the listbox.
I dont know what code to make the textbox save the "date video returned".