Is what I want called a subform?

[deusy]

I have created a form with four combo boxes made from different tables but
linked to one table with all the information. It is a custom work table
where different vendors own the equipment (is one table) , who performed the
work (another table, type of job done and rate that job cost (another table).


When I select the type of job in one of the combo boxes I would like it to
automatically fill in the next field of the form with the rate that the job
would be. I thought it would be a look up but currency field isn't allowed a
lookup. What is it called that I need to do a subform?

 

[BruceM]

Where does that rate information come from? If you can include it in the
combo box Row Source you can reference it in an unbound text box, with the
Control Source set to:

=[ComboBoxName].Column(2)

The numbering of columns is 0-based (the first column is 0), so Column(2) is
the third column.

If the rate is subject to change over time you would probably want to store
the rate information rather than just showing it as described above,
otherwise after a rate change the old records will show the new rate. If so
you could have something like this in the After Update event for the combo
box:

Me.Rate = Me.ComboBoxName.Column(2)

Rate is a field in the form's Record Source, and a text box (txtRate, maybe)
is bound to the Rate field.