Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Posts
    14

    Unanswered: One change to multiple records using Dynamic Update Query

    Hi Everyone,

    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!

    Thanks guys

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    What is your code so far? With a multiselect listbox, you can't simply refer to the listbox in a query criteria.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •