Is it possible to substitute an expression for the middle parm in a DLookUp function statement?

[MLH]

Instead of DLookUp(Field, Tbl/Qry, Where clause), I was hoping
to be able to substitute an expression for the tbl/qry parm

?DLookUp("[ClusterID]","tblAdmin INNER JOIN tblVehicleJobs ON
tblAdmin.TowCoID =
tblVehicleJobs.TowCoID","tblVehicleJobs.VehicleJob ID=GetCurrentVehicleJobID()")

Or, broken up into its 3 parts for legibility...

DLookUp
("[ClusterID]",
"tblAdmin INNER JOIN tblVehicleJobs ON tblAdmin.TowCoID =
tblVehicleJobs.TowCoID",
"tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobI D()")

I'm not having any luck. Wondering if it can even be done?

[Wayne Morgan]

You can create a query with the join you mention then use the query for the
parameter.

--
Wayne Morgan
MS Access MVP
"MLH" <CR**@NorthState.net> wrote in message
news:rt********************************@4ax.com...

Instead of DLookUp(Field, Tbl/Qry, Where clause), I was hoping
to be able to substitute an expression for the tbl/qry parm

?DLookUp("[ClusterID]","tblAdmin INNER JOIN tblVehicleJobs ON
tblAdmin.TowCoID =
tblVehicleJobs.TowCoID","tblVehicleJobs.VehicleJob ID=GetCurrentVehicleJobID()")

Or, broken up into its 3 parts for legibility...

DLookUp
("[ClusterID]",
"tblAdmin INNER JOIN tblVehicleJobs ON tblAdmin.TowCoID =
tblVehicleJobs.TowCoID",
"tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobI D()")

I'm not having any luck. Wondering if it can even be done?

[MLH]

Yeah, I understand that part. Was hoping to avoid having a saved
query. I guess that's not possible.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx x
On Sat, 17 Jun 2006 15:35:22 GMT, "Wayne Morgan"
<co***************************@hotmail.com> wrote:

You can create a query with the join you mention then use the query for the
parameter.

[Richard Birtwistle]

To avoid the stored query you could try

DLookUp
("[ClusterID]",
"tblAdmin",
"TowCoID = (SELECT TowCoID FROM tblVehicleJobs WHERE
tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ())")