Search results

probably didn't run it quite as expected, was in the forms VBA and stepping through with F8 could see all the changes in the msgbox and Locals window. It was run without other events being triggered, its a purpose made form that only focuses on the one field that i want to modify. It is hidden...

result is UPDATE Table3 SET Table3.Entry = '1/2' WHERE Table3.Entry = '1 / 2' which to me looks fine. I feel that this would work fine on a single text entry and not in a long string of text

Rabbie, thanks for that, now it steps though and I can see each look up value is looked at, but NO changes are being written, any other thoughts

I stole this from here, thought I could fathom how to adapt it for my use haha Sub Entry_GotFocus() 'Private Sub ChangeUoM_Click() Dim db As Database Dim rs As Recordset Dim strTABLE As String Dim strFIELD As String Dim strOLD As String Dim strNEW As String Set db = CurrentDb Set rs =...