This article explains how to create popup forms like the one below in Access:

Step 1:

Open the form in design view:

Step 2:

Change the Popup property to “Yes”:

See also:

• Open Form When Database is Opened, Access
• Access Form Design View
• Open Blank Form When Database is Opened, Access VBA

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website  www.software-solutions-online.com