Edit textbox in userform and write back to database using AfterUpdate

In your sample code you declare lngWriteRow but never assign a value to it so your line to update will fail with an error.

How do you load the textbox with data? That's where you should store the source row number in lngWriteRow - but remember to change the scope of lngWrkteRow, it cannot be local to the event.

cytop
text box is populated from double clicking a record from the first userform. I forgot to add file on initial post

Sorry, using a phone and there's no Android version of Excel... So will have to leave this for someone else to look at, but basically there's a double click event somewhere that loads the userform, you use that to also assign the current row value to a variable

Thanks cytop, there is a double click event I'll look into

Found a solution

Please Login or Register  to view this content.