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.

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)?

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).]