Update Multiple Recs from Form

maxsun08

Registered User.
Local time
Today, 10:05
Joined
Jul 27, 2012
Messages
15
Hello all,

I'm currently at a lost but here's what I'm attempting to do. In my Form, I would like to show a qry in either Continuous or Datasheet view. With that in mind, I want a user to be able to highlight multiple non-consecutive records or select those records via a chkbox. Then using an On Click command, certain fields in those selected records would update with a value from two unbound txt boxes.

I've searched quite a bit and haven't found much. Any guidance or assistance pointing me in the right direction is greatly appreciated!
 
Ok, I found some good info using a listbox to update my table (baldyweb . com/multiselectappend). So I have the code but I get a "Run Time Error 3164 Field cannot be updated." at
Code:
rst!ID = ctl.itemdata(varitem)

Any suggestions? Here's the code in use:

Code:
Set ctl = Me.listAMRRecords
  For Each varItem In ctl.ItemsSelected
    rst.Edit
    rst!ID = ctl.ItemData(varItem)
    rst!Cancelled = Date
    rst.Update
  Next varItem
 

Users who are viewing this thread

Back
Top Bottom