I have a form, frmTradeOff, which has a subform named frmTradeOffSub.
The frmTradeOffSub has a control called TradeWith which gets EmpName
from a lookup table entitled tblEmpName. On the frmTradeOffSub, there
is a control called TradeWithIDNum that I want to get IDNum from the
tblEmpName by using DLookup.

I am having problems figuring out the code since I am working with a
subform. Help is appreciated

Ron

Your posts been here a while with no response so maybe you've solved your
problem now.

This post isn't a proposed solution I'm afraid it's just to say that maybe
you have't got any proposed solution because it's difficult to understand
your problem.

I think that you need to provide
the query data that the main form retrieves [leaving out irelevant columns]
same for the sub form
the field names of the link fields

It may be clearer just to call the forms Main and Sub here

Hope this helps

Jim Bunton

"A_Classic_Man" <(E-Mail Removed)> wrote in message
news:1f5d4627-4dda-49fa-a93b-(E-Mail Removed)...
>I have a form, frmTradeOff, which has a subform named frmTradeOffSub.
> The frmTradeOffSub has a control called TradeWith which gets EmpName
> from a lookup table entitled tblEmpName. On the frmTradeOffSub, there
> is a control called TradeWithIDNum that I want to get IDNum from the
> tblEmpName by using DLookup.
>
> I am having problems figuring out the code since I am working with a
> subform. Help is appreciated
>
> Ron