It might. Why not try it and see if it works.
Or use the following.
Set Fax = DLookup("Tel","OneTable","Id=4")
I think John Vinson's solution will fail, since there is the possibility
of the subquery returning more than one record (as far as Access is
concerned) and therefore the update query will error.
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County