already answered in the other group, please don't cross-post to many groups
RAJESH DESAI wrote:
> Hi,
>
> I am trying to use the dlookup function to set the controlsource
> property of the unbound texbox as follows.
>
> txtExpDesciption.ControlSource = = DLookup("[Description]",
> "[ExpenseHeadMaster]", "[ExpenseHeadID]=" & Me.txtExpenseHead)
>
> The above expression is giving me #Name? result in txtExpDesciption.
> What could be the problem?
>
> I tested the Dlookup function with a msgbox, it is evaluating correctly.
>
> Please help.
>
> Regards,
>
> Rajesh
>
>
> ---------------------------------
> Here's a new way to find what you're looking for - Yahoo! Answers
>
> [Non-text portions of this message have been removed]
>
>
--
Brett Collings
Strengthening Families Administrator
D2D 46422
DDI (04) 916 3422
-------------------------------
This email message and any attachment(s) is intended only for the
person(s) or entity(entities) to whom it is addressed. The
information it contains may be classified as IN CONFIDENCE and may be
legally privileged. If you are not the intended recipient any use,
disclosure or copying of the message or attachment(s) is strictly
prohibited. If you have received this message in error please
notify us immediately and destroy it and any attachment(s).
Thank you. The Ministry of Social Development accepts no
responsibility for changes made to this message or to any
attachment(s) after transmission from the Ministry.
-------------------------------
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
