Updating Fields on a Form from two tables...

[Mortal]

I am creating an Access DB for the first time in years and in doing so have forgotten how to update fields from two separate tables.

Here is what I am trying to do:

When a user selects a store that is linked as a lookup of the second table.
I want the address to autofill from the second table and update the first.

How would I execute that?

 

[SydneyGeek]

Hi Mortal,

This question was asked by another person today. Check out the answer here.

Denis

 

[Mortal]

Great thanks

Thanks a million...