I have created a form that displays data that is linked to a permission table. If the permission table lists the current user as a "Manager" then it will also open another popup that contains the menu buttons and other controls. It works fine but I would like to dock the two forms together so I looked up the following question and found some code that I thought would help. http://www.experts-http://www.experts-exchange.com/Databases/MS_Access/Q_21462025.html?query=set+as+form&topics=39
I've created the class module and copied the two subs into my application, then I tried using the following commands but they don't work as I thought they should. frmMainMenu is set up to Auto Centre so it correctly centres itself on the screen. The menu frmAdminMenu should, I thought, position itself at the top of frmMainMenu, instead it positions itself at the top of the screen over the top of the main Access Menu. Can anyone tell me what I need to do to make it work?
Dim FormA As Form
Dim FormB As Form
Set FormB = [Forms]![frmMainMenu]
Set FormA = [Forms]![frmAdminMenu]
Call AlignTops(FormA, FormB)