Record Value in Visual Basic

[chrismec]

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:

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:

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!

[RuralGuy]

You would probably need to do a DLookup() to get the other value.

[chrismec]

Thanks RuralGuy! Dlookup works great!

[RuralGuy]

You're welcome. Do you want to go ahead and follow the link in my sig and mark this thread as Solved?