**PBaldy** Update Record in Listbox

[UserX]

Pbaldy,



I used your suggestion from this post: https://www.accessforums.net/showthr...6&goto=newpost and the suggestion is coming along nicely; however, I have one minor problem, and I was hoping you could help me solve this.

Take a look at my attached sample; the Sign-in Log form. What I'm trying to accomplish is a way to edit/update a selected record to be able to add in a time value for the "TimeHelped" column in the listbox, while using the Form View. I tried to use a text box with the "rs.Edit" command, instead of "rs.AddNew" (like you did with your sample MultiSelectAppend db's "Other value" box), but this returns an error "No current record."

Do you have any suggestions on how I might accomplish this?

Things I've tried:

1. Split Form - only shows the TimeHelped box in the form and table
2. Text box - as mentioned above
3. Changed Row Source Type to "Value List" - This results in the records in the table no longer visible, and the column headers show, verbatim, the characters in the Row Source filed ([sign_in].[LastName]...)
4. Attempted to make a subform, but for some reason I can't explain, this function is unavailable, as the button that enables/creates remains grayed out, even with a completely blank and unbound form

[pbaldy]

Untested but try replacing this line:

Set rs = db.OpenRecordset("sign_in", dbOpenDynaset, dbAppendOnly)

with:

strSQL = "SELECT * FROM sign_in WHERE ID = " & ctl.ItemData(0, varItem)
Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)

but put them right after the For line.