Sam,
I recommend that you always begin the name of tables with Tbl and never use
spaces or continuation characters in names. You'll be glad you did when you
start writing code for your applications.
To answer your question ---
Open to the database window, select forms and press New. Select the Form Wizard
to help you build the form. Follow the directions of the wizard. When it asks
you for the source of the data, point to your Borrowers table. At the point it
asks you what type of form, select Columnar. Once the wizard is done, close
everything. You will be asked for a name of the form. Name it MyForm.
Forget the Switchboard!!! You'll spend your whole Access career trying to figure
how it works and you'll go gray way before your time - that is if you have any
hair left after the frustration caused by the switchboard. In lieu of the
switchboard, create a second form. With the form in design view, open
properties, go to the Other tab and make pop-up Yes. While still in design view,
open the Toolbox (button on toolbar at top of screen), select command button,
move cursor to form and draw in a command button. Select the button, open
properties, go to the Other tab and name it MyButton. Then click on the events
tab. Click on the white box at OnClick. A button with three dots will appear at
the far right, click on it. In the Choose Builder window, click on code builder
then OK. This will take you to the code window behind your form. Two lines of
code will be shown. Type this in between the two lines:
DoCmd.OpenForm "MyForm"
DoCmd.Close acForm, "MyPopupForm"
Close everything. You will be asked for the name of the form. Name it
MyPopupForm. Now that you are back at the database window, click on Tools -
Startup in the menu at the top of the screen. At the top right of the screen
that appears, it asks you Display Form:. Use the drop down arrow and select
MyPopupForm in the list.
Close everything and close Access.
Restart Access.
You're on your way to becoming a power Access user!!
