Auto populate fields after inserting a records in column 1

[sovietbiker]

Using Access 2013 app. I have two tables. Table one has all of my product information.

1. Product id
2. Product Name
3. Product Location

In Table two I have a lookup column for Product id. I want to auto fill product name and product location into columns. The reason I am bringing them both into table two is that the users will be expanding on the data entry and adding more information to the records.

How do I auto populate fields based on an ID from another table.

Thanks!

[pbaldy]

How about:

http://www.baldyweb.com/Autofill.htm

[sovietbiker]

No, this doesn't really work for me using an access app.

I almost have it using a SetProperty after update. Unfortunately, I can't get to return a value from a table. It just returns yes or no. Any suggestion on how to get the Set Property macro to return a value from a table.

Thanks

[pbaldy]

Well, if you're using a form and a combo you'd include the fields in the combo row source. If you don't like the code I posted, a macro can do the same thing.

[emihir0]

Why would you need to have all 3 columns in your second table?

That seems like a design flaw.

However, what you are trying to achieve (from what I understood) can be easily done using a query - something along the lines:

SELECT t1.a1, t1.a2... t2.a1, t2.a2...
FROM t1 INNER JOIN t2 ON t1.somePK = t2.someFK;