autofill Form

L

Laura

I am trying to autofill to rows in my form. When the dataentry person enters
in the EIN of a company I want the company name to automatically appear. I
am not for sure how to do that, can someone help??? There are about 400
companies.

Thanks for the help.
 
J

John Vinson

I am trying to autofill to rows in my form. When the dataentry person enters
in the EIN of a company I want the company name to automatically appear. I
am not for sure how to do that, can someone help??? There are about 400
companies.

Thanks for the help.
Click to expand...

The simplest way is to have the user SELECT - not enter, though they
can type it to have the combo autofill- the EIN using a Combo Box. If
the CompanyName field is included in the combo box, you can set the
control source of a textbox on the form to

=comboboxname.Column(1)

to display the second (it's zero based) field in the combo's
recordsource.

You should NOT be storing the company name in your form's table - only
in the 400-row company table. It's redundant, and you can always use a
combo box or query to look it up.


John W. Vinson[MVP]
 
L

Laura

Thanks, I'll try that.

John Vinson said:
The simplest way is to have the user SELECT - not enter, though they
can type it to have the combo autofill- the EIN using a Combo Box. If
the CompanyName field is included in the combo box, you can set the
control source of a textbox on the form to

=comboboxname.Column(1)

to display the second (it's zero based) field in the combo's
recordsource.

You should NOT be storing the company name in your form's table - only
in the 400-row company table. It's redundant, and you can always use a
combo box or query to look it up.


John W. Vinson[MVP]
Click to expand...
 
Top