Mocha Float
New member
- Local time
- Today, 13:52
- Joined
- Feb 15, 2013
- Messages
- 9
Hello,
I'm working in the Before Change data macro of a table (call it table A) using a For Each Record loop in table B. table A has a field that contains ID's of records in table C. I'm trying to check if a certain value in table B is equal to a value in table C with a corresponding ID from table A. My question is:
How do I reference the value in table C that corresponds to the ID (which I know) from table A?
PS: This is in Access 2010 Web
I'm working in the Before Change data macro of a table (call it table A) using a For Each Record loop in table B. table A has a field that contains ID's of records in table C. I'm trying to check if a certain value in table B is equal to a value in table C with a corresponding ID from table A. My question is:
How do I reference the value in table C that corresponds to the ID (which I know) from table A?
PS: This is in Access 2010 Web