Hi Tom, I just uploaded a demo in access2000 of how I think I'd do it. Don't know if I got the problem right but I hope it helps. It's in the Files > Demos & Sample Files > A2000 Samples directory and it's called Doctors.mdb
Regards Robin. --- In AccessDevelopers@yahoogroups.com, "Tom Oakes" <[EMAIL PROTECTED]> wrote: > 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 > > > I am using DLookup on Form properties to pull through default values. > 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. > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > _____ Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
