DLookup Problems

[ShadyOne]

I have two DLookUp's in one form. If I use one, the other doesn't work. So for an example if I select DLookUp 1 then DLookUp 2 doesn't work. Or if I select DLookup 2 then DLookUp 1 doesn't work. Has anyone heard of this problem, and if so, how do you get around it?

Thanks.

 

[DML]

Could you post both Dlookup calls to show your syntax and criteria? Where are you using Dlookup (in the default value property, control source, or in code)?

 

[ShadyOne]

These strings were placed in the control source.

DLookUp one:

=DLookUp("[CC#]","[Site]","[Location]",=Forms![Entry form]![Location]")

DLookUp two:

=DLookUp("[CodeX]","[AccCode]","[Description]=Forms![Entry form]![Account Descritpion]")



[This message has been edited by ShadyOne (edited 07-14-2000).]