autofill Form

[Guest]

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.

 

[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.

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]

 

[Guest]

Thanks, I'll try that.

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]