Robin, Neil, Tom Many thanks for your input. Yes the Doctors come via a Combo from a relational Doctors table, used to populate various other tables. Am looking at Robins work as looks very helpful.
I suppose what I'm getting at is that since DLookup is a bound control, substituting any default values pulled through from the parent table is not a straighforward process, even though the substituted value is stored in another table from the parent? Will post if I come up with anything else. Many thanks again to all. Ian --- In [email protected], "Robin" <[EMAIL PROTECTED]> wrote: > 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 [email protected], "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: [email protected] > > [mailto:[EMAIL PROTECTED] On Behalf Of ianiber > > Sent: Wednesday, July 06, 2005 7:34 AM > > To: [email protected] > > 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/
