inherit values

[jkanters]

In my table2 I have a field called field2 which is a combo box. The values
are found in table1 in field10.

Then I want in my form to show field9 from table1 corresponding to the value
in field10.

How do I manage that?

 

[JEA]

Sounds like you need to look up normalisation.
What happens if you want to add another value to the combo box? You're going
to have to add a whole new record to table1.

Anyway, a DLookup would work. On the form you want to display this create a
text box. In that box type:

=DLookup("[field9]", "table1", "[field10] = [comboBox]")

comboBox is on the same form in this example.

I strongly suggest you read up on normalisation, you may get loads of
problems later if you don't.