'What is the correct MS Access expression within a form to return a value from one field related to another field in the same table?

I have a database of student travelers on an international tour. Each student picks three others as roommates, and I need to associate each roommate ( [R2] [R3] and [R4] ) with their respective contact phone numbers. I thought a DLookup function would work, but there seems to be an error.

=DLookUp("[Phone Number on Tour]","[June 2022 Travelers]","[Phone Number on Tour] = " & Forms("Rooming Roster")("[R2]"))

I can obviously create duplicate fields in the table to include the appropriate phone number associated with [R2], [R3], and [R4]; however, I'm trying to avoid having to duplicate field content.

Anyone have any thoughts on this?

Thanks in advance.

expressionfieldrelationship


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

How to determine an object's value in Python

javascript - match string against the array of regular expressions

After Effects Expressions - controling comps from main comp using an "Expressions Layer"

How can I use a built Expression in an Include .Where() to apply an Include Filter when it expects Expression but only allows Func?

print when expression to display Static text if there is atleast a not null field in a detail band

How can I filter in Birt (Parameter) on a computed column?

LINQ Expression GroupBy Select First

IQueryable extension to group dynamicly by minutes ...and other

Difficulty in create regex [duplicate]

Regex to match code with fixed country code and variable wildcard usage

How to sort entity model by column name of display model in C# .NET Core using LINQ?

mapbox : how to combine two expressions to style a layer?

Evaluate String expression in Swift just like javascript eval

IP Address regex with netmasks

Expression to check if a given string exist in a output of a script task in ADF