Automatically populate a field

  • Thread starter Thread starter Jenn
  • Start date Start date
J

Jenn

I have a table that lists our hauling descriptions and
their corresponding rates. In my form, I have based a
combo box on this table to look up the description. I
need the corresponding rate to populate in another field
on the form.

Sorry if this is a silly question. (It is silly because
I used to know how to do all of this stuff!)

Thanks so much!
 
Set the rate as a hidden column in the combo box row
source, so that when a description is selected, you can
retrieve the rate from the combo box value:

for example:

If the Description combo row source is:

SELECT Description, Rate FROM tblDescRate

You would:

Set the ColumnCount property to 2
Set the ColumnWidths property to 1";0"

(this will hide the rate value in the combo box)

After a description is selected, you can set the rate
field:

Me.RateField = Me.Description.Column(1)
 
Back
Top