We will create one more form that acts as the main opening form. This form will let an end user choose what to do when the document is loaded. This means an end user does not need to know how to navigate in Access.
Create a form that has a single button. Make sure you do not associate the form to any table or the button to any built-in functions. Switch to the Design view. Right-click the button and select “Properties”. In the “Properties Sheet”, select the “Other” tab, and change the name to “userDataEntryButton”. In the ‘Format” tab, change the caption to “Edit Users”.
Then, in the “Event” tab, click the drop-down box next to “On Click”. Select “userDataEntry”. This associates the macro that we just created to the click event of this button.
Last, let us change some properties of the form itself. Scroll the form to the right or down until you see areas outside of the form. Click that area. Then, click “Format” and change the “Caption” to “Main Form”. Then right click the tab and save the form as “mainForm”.