Update table column of selected records in listbox (1 Viewer)

spudracer

Here and there
Local time
Today, 01:44
Joined
Jul 1, 2008
Messages
199
I've got a listbox that I'm trying to run a command that will set a checkbox value in the associated table to yes.

The listbox (lstPersonnel) has two columns (Name and Member Number). What I want to happen after I select the records I want, is to update the value in those records (MemberSelect) in table (tblPersonnel) to yes.

I've gotten hung up on the code portion as what I've found only returns one of the names from the list.
 

Gasman

Enthusiastic Amateur
Local time
Today, 05:44
Joined
Sep 21, 2011
Messages
14,048
And that code would be?........
 

spudracer

Here and there
Local time
Today, 01:44
Joined
Jul 1, 2008
Messages
199
And that code would be?........

I’m not at my computer right now, so I don’t have it readily available. In all honesty, I hodgepodged some code together to see if it would work, but I’m hung up on setting the recordset to just select the records based on the list box selections.
 

Users who are viewing this thread

Top Bottom