Dlook Up against a query

[NigelBrown]

Hi all,

I have the below code but cannot get it to work, missing operator ?

GroupOwner1 = DLookup("GroupOwner", "tbl_GroupOwners_Master", "Group Mapping = ???")
 

the problem I have is where I have the ????, I want this to refer to a column in a query called GroupMapping, is this possible. I want to open the query and call the function which in turn looks at the data in GroupMapping and returns the group owner from the tbl_GroupOwners_Master ? Any help will be greatly appreciated

Thanks
Nigel

[NigelBrown]

Actually all,

I have written the beow in a select query but it errors, banging my head against the wall, does anyone have any ideas please ?

GroupOwner: DLookUp("[GroupOwner]","[tbl_GroupOwners_Master]","[Group Mapping] =" & Nz([GroupMapping],0))

I have two tables in my select query "table A that contains [GroupMapping] and tbl_GroupOwners_Master.

Thanks
Nigel

[nico5038]

The only problem I can see is when the [GroupMapping] is a text field. The code for that would be:

DLookUp("[GroupOwner]","[tbl_GroupOwners_Master]","[Group Mapping] ='" & Nz([GroupMapping],0) & "'" )
 

as it requires surroundung quotes.

Nic;o)