Unanswered: One change to multiple records using Dynamic Update Query
I'm trying to setup a 'one change to many records' function on my database using an Update Query.
So far i have a list box with all the students, and i want the user to be able to select multiple students (multi select list box) and then specify the change and run it.
However i'm having trouble getting the criteria into the update query - i thought i would just be able to link the criteria of the update query to a text box and make that text box reflect the Primary Keys of the students i have selected in the list box. This would obviously go into my 'Where' on my Update query.
The problem is that when i link the criteria to the text box and run, it for some reason the update query doesn't read properly and tells me it will 'update 0 rows' however if i type exactly the same thing that i have in my text box into my query criteria manually it works fine!