DLookup function ... Pl help (1 Viewer)

[gdanalakshmi]

I am using a DLookup function in my code
It is like this

Dim varX As Variant

varX = DLookup(GroupToGroupMember.GroupMember_ID, GroupToGroupMember, _
GroupToGroupMember.Group_ID = CDbl(Me.Group_ID) And _
GroupToGroupMember.GroupMember_ID = CDbl(Me.GroupMember_ID))

And in the criteria, I am checking for the 2 table fields matching.

I am getting "Object required" error message.

I tried a lot of options , nothing is working...

Any solution to fix this problem???

 

[Peter D]

Try this:

varX = DLookup("GroupToGroupMember.GroupMember_ID","GroupToGroupMember", _
"GroupToGroupMember.Group_ID = CDbl(Me.Group_ID) And GroupToGroupMember.GroupMember_ID = CDbl(Me.GroupMember_ID)")

Hope this helps,

 

[gdanalakshmi]

When I try your statment , I get the following error...

The object doesnot contain the Automation Object Me.Group_ID

 

[WayneRyan]

gdanalakshmi,

varX = DLookup("[GroupMember_ID", _
               "GroupToGroupMember", _ 
               "[Group_ID] = " & CDbl(Me.Group_ID) & " And " & _
               "[GroupMember_ID] = " & CDbl(Me.GroupMember_ID))

Wayne