Populating a form from a diff table

If I type in a vendor number in my products form - can I get the vendor name
to pop up on the form (withought having to type it)? People will be entering
the data into the form, but to keep it efficient they only need to enter the
vendor number, but I would like the form to then show the corresponding name
so that they can check themselves.

Let me know.

Thanks,

Stephanie

On Wed, 27 Dec 2006 13:40:01 -0800, steph44haf
wrote:

If I type in a vendor number in my products form - can I get the vendor name
to pop up on the form (withought having to type it)? People will be entering
the data into the form, but to keep it efficient they only need to enter the
vendor number, but I would like the form to then show the corresponding name
so that they can check themselves.

Let me know.

Thanks,

Stephanie

Easily. Use a Combo Box to enter the vendor number and put a textbox
next to it; include the vendor name in the combo's Row Source query;
set the control source of the textbox to

=comboboxname.Column(1)

to display the *second* column of the rowsource (it's zero based).

Or, you could even use two combos, one displaying the vendor number,
the other the vendor name; the name combo will autocomplete so it's
probably even easier than memorizing and entering the number, and you
can see the vendor both by name and by number.

John W. Vinson[MVP]