Default value based on input of corresponding list box field

  • Thread starter Thread starter Lori Mihalko
  • Start date Start date
L

Lori Mihalko

Hello,

I have a field in a table that has a list box lookup
based on a query. In the query, there are 2 columns, A &
B. When I select a value from column A in my field with
the list box lookup, I want the corresponding value from
column B to default into another field in the table.

Example: Field1 in table1 calls for a part#. The part
number is selected from the list, which is calling
query5. In query5, there are 2 columns. Column1 is
equal to field1 when selected from the list. I want
field2 of table1 to have a default value equal to column2
from query5, corresponding to the value that was selected
in field1.

Please assist me with the setup of this default value.

Thanks,
Lori Mihalko
 
Back
Top