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