thank you for your help. But I already have the code to update all.
I now figured out that when I do "me.hide" the userform it works but it doesn't work when I do "unload me". I would prefer to have the "unload me" solution.
Do you know why it makes a difference between unload and hide?