I have a field in a table that is a Lookup to another table. The Lookup field displays the title of a Bible Study Course, but is bound to an ID from the Bible Course table (rightly so).
I'd like to copy the Bible Course Title into a new field, but in order to do that I need a macro that can lookup the ID and then convert the ID to the Title. (I'm copying Fall course titles to Spring course titles)
This macro currently works, but takes too long to process: https://drive.google.com/open?id=0Bzc-OnhLGLTmWHNEYnlyci1oZjQ
Also, I'd like to not have to use the "ForEachRecord" command, which is updating each record in the table. I'd like to only update the current record if possible.
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.