Selecting multiple values and editing their location

[nc22]

Hi,

I would need the ability to select multiple values from either 1 or multiple list boxes and change their location value.

I have made a make table query with the data needed stored in two fields "Tape Barcode" & "Field1". From there I have created a form but now I am stuck. Cold someone guide me as far as how to be able to select multiple values using the form and changing the selected values location? I am not able to seem to find the answer on my own and the best possible solution.

Many Thanks,

Nick

[June7]

I don't understand what you mean by 'selected values location'. What is 'location'? A multi-value listbox is easy to do but using the selected values requires VBA code unless the listbox is bound to a multi-value field in table. I never use multi-value fields.

Need a better understanding of your data structure and form design. Want to provide db for analysis? Follow instructions at bottom of my post.

[nc22]

I'll see how much I have to remove for me to be able to post the DB.

But for now:

I have the form bound to a table. Table was made from a make table query
The form would contain a multi-value listbox as you say or several list boxes - These would contain all the barcodes from our different matrials.
The barcodes would be scanned via scanner.
From there when I would click the "Update" button on the form all the selected values from the various list boxes or multi-value listboxes would have the location field updated on the table to "Reserved".

Hope this helps for now. I dont mind going the VBA way just would need help as to how to get there.

Nick

[June7]

The listboxes provide criteria for targeting record(s) for update? Would be easiest if the criteria could be resolved to a unique ID.

Using listbox selections requires cycling through the listbox and acting on the selected items. Review http://allenbrowne.com/ser-50.html

In your case, instead of building a complex string for the WHERE CONDITION of an sql in the loop, use code that will update record defined by the individual listbox criteria.

CurrentDb.Execute "UPDATE tablename SET fieldname='Reserved' WHERE ID=" & Me.listboxname