Wednesday, July 11, 2012 10:35 PM
I'm looking for a VBA solution in Access to emulate a VLOOKUP in Excel. I have two tables with a common key field. From the first table, I want to look up the key value in the 2nd table and place the value from the 2nd table into the field of the same name in the first table. I need to do this for all records in the first table. Any help would be appreciated. Thanks!
Wednesday, July 11, 2012 11:38 PMMight I suggest a simple update query? Create a relation btw the 2 tables on their common key and then you should have no problem pushing the desired data intothe appropriate field. If you must it can be ported to VBA.
Thursday, July 12, 2012 1:10 PM
Wow!!! I completely forgot about update queries. I'm so embarrased. Thanks so much and sorry to have taken your time. Thanks!
Thursday, July 12, 2012 1:38 PM
No reason to apologize for asking a question! Do you the number of times I've spent hours writting VBA code and all of a sudden realized it could have been done in minutes using a series of queries.
Glad I could help!