field in one to automatically fill in

[deusy]

I have a form with combo boxes. When you enter select the type of job a
person is performing I would like the rate field to automatically pull from
the table the rate for that type of job. I have set up combo boxes in my form
for you to choose the job the person is performing but can't figure out what
I need to do to pull the rate.

I have the job the person is performing and the rate in one table. Does
anyone know what this is called so I can look it up or explain what I need to
do. Thanks.

 

[Linq Adams via AccessMonster.com]

You only need one combobox. Set it up, and when asked for the fields to
include, first move the Job field over, then the Rate field over. Then use
this code, replacing the names of the various controls with your own actual
names:

Private Sub cboJobCombo_AfterUpdate()
Me.txtJob = cboJobCombo.Column(0)
Me.txtRate = cboJobCombo.Column(1)
End Sub