Running an update query from list box multiple selections

[coline]

Hi, I would like to do data entry for several records that appear in the same table (and usually only appear one at a time on a form). I am thinking that I could dispaly the relevant records in a list box and then run an update query for those items selected in the list box by the user, but I'm not quite sure how to set this up. I'd appreciate your comments on whether this is a good plan, and if so, some pointers on how to set up an update query to run off listbox selections.

Thanks in advance,

Coline

 

[Norie]

What do you want to update?

You could have the listbox, and then below a number unbound textboxs with the info that is to be updated.

Each time a record is selected in the Listbox insert the current info for the record into the textboxs. The user can then change the data as wanted.

Then to update the record have a Command button that runs an update query.

e.g DoCmd.RunSQL ("UPDATE Table1 SET Table1.[Value]=" & v & " Where Table1.ID=" & i)