function or sub? it shouldn't matter. Anyway, I couldn't find the exact function I was looking for, but the jist of it is
sub Whatever()
do some stuff
frmFormName.Show
(form does its thing, in the button click event, put me.hide )
Focus returns here
end sub