Auto filling field based on information entered under another field

[antwun91]

Hi,

I have a table with various metal types and the price per gram and another table with jobs. Using the form for jobs I am trying to have a box autofilled with the price per gram depending on which metal is selected.

I apologise for the terrible wording.

Anthony

[RuralGuy]

A query joining the metal table and the Jobs table will do that for you.

[NTC]

Assuming your metal selector is a combo box; what you do is include the grams field also in the query that the combo box is using (it is in the combo box property).

Then you have a choice to either link to that gram field and display it - or - call it (write) it permanently into the table of the form you are working in.

Either way the syntax is going to be something like: Me.ComboboxName.column(2) where the grams field is the 2nd field.....