dlookup control source

[ogilby1]

when using/writing dlookup the expression should be placed in the control
source field of the properties? under what circumstances is it "put" in the
beforeupdate" or "afterupdat e"?

[Fredg]

Re: dlookup control source

For one example:
You would use the DLookUp() to determine if an entry in the control was
already entered previously in a table, in other words, compare a new entry
with an existing entry. If you place the comparison in the control
BeforUpdate event, you can then cancel the entry if a duplicate exists.

Use DLookUp wherever it's needed.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


"ogilby1" <ogilby1@insigh tbb.com> wrote in message
news:gSQ4b.3261 11$YN5.224844@s ccrnsc01...[color=blue]
> when using/writing dlookup the expression should be placed in the control
> source field of the properties? under what circumstances is it "put" in[/color]
the[color=blue]
> beforeupdate" or "afterupdat e"?
>
>[/color]