Selecting records and updating a field in only those selected

[katipiders]

Hello,



I have a bit of a quandary. I want to be able to select certain records in a form and update only one field in those selected records at once.

Here’s an example,

Say I have a list of individual invoices, but only want to apply some of those invoices to a single check. I would like to select those invoices from the list and add the same requisition number to all the selected invoices.

So here in the below form, I want to select the first and third invoice and update the requisition field with same value, leaving the middle invoice untouched.



Any thoughts?

[aytee111]

Listbox's allow multi-select, maybe you could change it to that, use the subform as display only.

[Micron]

Since your picture example shows that you want to choose non-contiguous rows, you can't use the SelTop and SelLength properties of the datasheet form. I mentioned this anyway for the benefit of any future readers of your thread who might be able to use that. The suggestion to use a listbox is a good one, as long as you're OK with the number of list items it contains and how far apart they are when selecting. If there are a lot of items and I'm navigating many rows apart, I'd rather have two list boxes because since it's likely some of the chosen items will not be visible when I'm done selecting and I may not notice a mis-click. The second one is for moving the chosen list items into, then updating the necessary fields for the second set.

[CJ_London]

you might find the 'multiselect' form in this thread of use


https://www.accessforums.net/showthread.php?t=61811

you can then have code to split the SelectedList value to run update queries