By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,233 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

dlookup control source

P: n/a
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 "afterupdate"?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <og*****@insightbb.com> wrote in message
news:gSQ4b.326111$YN5.224844@sccrnsc01...
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 "afterupdate"?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.