Forum Discussion
odiez790
Apr 13, 2024Copper Contributor
Cannot get to edit on my user form to save data
have a user form that I can choose a surname, then it displays up to 5 members of family if there are 5, but I cannot get it to save when I press the Edit and save button. Getting error (when I ope...
HansVogelaar
Apr 13, 2024MVP
You refer to a variable fa but don't set its value. Because of that, the condition
Loop While Not f Is Nothing And fa <> f.Address
is never met, and the loop would continue endlessly. You have two lines
If Not f Is Nothing Then
in your code. Below each of them, insert
fa = f.Address