Default value based on input of corresponding list box field

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default value based on corresponding value selected from list box 3
Field Default Value 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Requiring one field contingent on data in another field 0
lookup question 1
Report based on Query 1
Help with dropdown list limit based on previous field selected 2
Best way to setup a field if different info needed based on type 3

Top