|
|
|
date: Tue, 8 Jul 2008 13:45:42 -0700 (PDT),
group: microsoft.public.access.tablesdbdesign
back
Re: Autoupdate a field based on another field
On Jul 8, 4:00 pm, Danny Seager
wrote:
> Use a Dlookup()
>
> =Dlookup("FieldName","TableName","OfficeNumber=" & me.OfficeNumber)
>
> Not you should not store this value though, it can be looked up when you
> need it in a query
>
>
>
> "CJ" wrote:
> > Hello,
>
> > In my database, I have an Office Number and an associated EU title.
> > Due to structure needs I cannot combine these two pieces of
> > information, but when the Office number is entered, I want the EU
> > Title to autofill. I just don't know how to do this, any suggestions?- Hide quoted text -
>
> - Show quoted text -
Thanks Danny!
I haven't used this before, would it go into the record source on the
proerties field? When using this, will it work off of a drop down
field?
date: Wed, 9 Jul 2008 10:20:57 -0700 (PDT)
author: CJ
Re: Autoupdate a field based on another field
It will go in the control source of the text box where you want to display
the looked up data
"CJ" wrote:
> On Jul 8, 4:00 pm, Danny Seager
> wrote:
> > Use a Dlookup()
> >
> > =Dlookup("FieldName","TableName","OfficeNumber=" & me.OfficeNumber)
> >
> > Not you should not store this value though, it can be looked up when you
> > need it in a query
> >
> >
> >
> > "CJ" wrote:
> > > Hello,
> >
> > > In my database, I have an Office Number and an associated EU title.
> > > Due to structure needs I cannot combine these two pieces of
> > > information, but when the Office number is entered, I want the EU
> > > Title to autofill. I just don't know how to do this, any suggestions?- Hide quoted text -
> >
> > - Show quoted text -
>
> Thanks Danny!
>
> I haven't used this before, would it go into the record source on the
> proerties field? When using this, will it work off of a drop down
> field?
>
>
date: Thu, 10 Jul 2008 06:18:00 -0700
author: Danny Seager
|
|
