if you want to open form x, you just need to declare form x and open form x in the form you want to open from. Such as, you are on form y and want to open form x
dim fx as new formx
fx.open()
me.close()
from form x you want to open form z
dim fz as new formz
fz.open()
fx.close()
and so...