Are the doctors selected from a combo? If the default
specialty is stored with the doctor, you can set it when the doctor is selected,
via the combo's AfterUpdate event. You could either use DLookup, or simply
put the specialty in the combo's source and reference it there, which would be
my choice.
Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946
(C)
713.583.7091 (F)
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ianiber
Sent: Wednesday, July 06, 2005 7:34 AM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] DLookup - A default value that can be overwritten
However, I need functionality where these default values can be
overwritten on a case by case basis.
e.g. selecting a Doctor would pull through their usual specialty.
However, occasionally one might need to overwrite that specialty in
individual cases. So that Dr X would normally default to Respiratory,
but may occasionally have his default changed when working in a
Coronary setting.
Any ideas on a method to achieve this would be welcome. Thanks.
Please zip all files prior to uploading to Files section.
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
