automatic entry

J

Jerry

I would like to have data populate fields if something is picked in another
field. Example {Sales Person Field} someone picks John Smith I want the field
{Email Address Field} to automatically fill in with John Smith's email
address.
 
J

John W. Vinson

I would like to have data populate fields if something is picked in another
field. Example {Sales Person Field} someone picks John Smith I want the field
{Email Address Field} to automatically fill in with John Smith's email
address.
Click to expand...

Well... you probably DON'T want to do this. Storing data redundantly
is almost never a good idea! Store the EMail address once, and then
use Queries to link to the Salespeople table to pick up the email
address.

If you just want to see the email address on the form (without storing
it in the Orders table) include the EMail field in the Salesperson
combo box's RowSource; set the combo's Column Count big enough to
include it; and put a textbox on the form with a control source

=cboSalesperson.Column(n)

using the actual name of your combo box, with (n) being the *zero
based* index of this field in the query.

John W. Vinson [MVP]
 
Top