Running Update Query On Selected Items Only

[sdrmason]

Hello,
I have a problem and I am not returning much luck via google. Here goes...
I have a continuous form, which is based on a query, it displays a set of records, I then need to be able to tick a box on certain records and "mass update" the 'Costing Status' Columns of those selected values.


As this database will be used by multiple users at once the checkboxes cannot be bound to the record as this would be a problem with multi users. (Originally I put an extra field in my main table called "selected" and set the buttons to run an update query based on that, I didn't think about the impact of two users in the system).


Another theory was a list box however this presents a "presentation" issue as often our field names are longer than the columns and need to be wrapped over two lines.


I need to somehow tell an update query to run on a select few records.


I have tried to attach a photo however I have had to blackout some details also at http://tinypic.com/r/km1yh/8






Any ideas would be greatly appreciated!


Cheers,
Steve

[pbaldy]

One alternative would be to copy the desired records into a front end table that also had the extra field, and base the form on that. Then your update could be run against the actual table.

[ranman256]

The checkbox MUST be bound to the record to order to indicate what to change.
You could extract to a local table THEN run the update.

[sdrmason]

I loosely follow you, it must be said I am probably advanced yet nowhere near expert! Could you dump this down a little, how do extract the data into the local table? I assume this table is a virtual table held by one user on their PC as such?

Thanks for your help, been at this for days now, I thought it would be a fairly common procedure!

[pbaldy]

Typically I'd probably use a listbox. Presuming your application is split (and it should be), you'd have a table in the front end that you empty/populate when needed for this form. Simplest way to populate is probably an append query. Since it's in the front end, each user would be independent of each other.