Automatic Field Population in a form

[Guest]

I have a table named "Employees" that has the employee name and billing rate.
I want the form to automatically populate the billing rate field when I
select the employee name from a combo box.

 

[Wayne Morgan]

Add the billing rate field to the combo box's Row Source query. Set the
width of this column to 0" if you don't want it visible. In the textbox, set
the Control Source to the value of this column.

Example:
=MyCombo.Column(1)

The column index number is zero based, so the first column is 0, the second
is 1, etc.