Hello All. I am new to access and cant seem to get past this stumbling block.
I need to add values from different records in a table in visual basic. I understand that I can add values from the same record with the following method:
Code:
Me.NewValue = Me.Value1 + Me.Value2
What I need is to add a value from the current record with the value from a different record. Such as:
Code:
Me.NewValue = Me.Value1 + AnotherRecord.Value2
But I can not seem to find what code I need to insert in place of 'AnotherRecord'.
Thanks for your help!