Link to help step by step to create autofill forms

[Guest]

Hello,

Does anyone know of any links to help new users to create a autofill form in
Access that shows step by step or video of how to do this.

I have a small database in Access with name, office, phone, fax and email.

I want to create a fax form where a combo box for name is pulled down, the
person's name is selected and the rest of that person's information is
autofilled in other text boxes.

Any help, advice and/or assistance is so appreciated.

Thanks,
MSnewbie

 

[Guest]

Its as simple as this.

1 make your table
2 highlight the table you have made in the tables window (it should go grey)
3 Click on the insert menu on the top row of your menu bar (Top of Page) and
select at the very bottom of the drop down menu, insert autoform.

This will generate a form with all the controls in place for your Name,
Office, Phone, Fax & E mail.

4 Now select the form and right click on it and select design view.
5 This will take you into the design of the form. From the toolbox (Toolbox
is available from the view drop down menu and it icon is a spanner and
hammer), select a combobox. (Hovering over the tools will display a combobox)
Drag the combobox where you want in on your form. (Click the combo box, click
on the form and drag out the combo box)
6 This will start the wizard.
7 Select the third option on the wizard, Find a record on my form based on
the value I selected in my combobox.
8 Press Next
9 From the available fields on the left, select the field Name and click the

button

10 Press Next
11 Adjust the width of the name to fill the width you want
12 Press Next
13 Type the name you want to give the ComboBox "Name" would be good.
13 Run the form in view mode
14 Finished, try it out but you will need some records in the table.

I have given you the easiest way, no query no form design apart from the
combobox addition. I have a database set up like this based on the info you
have given that works just fine. Assumes you have Access 97 2k or 2k3

Hope This Helps

Mike

--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all
and asked everyone you know,
read the instruction manual.