Autoupdate a field based on another field

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

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?
 
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
 
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






- Show quoted text -
Click to expand...

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?
 
It will go in the control source of the text box where you want to display
the looked up data
 
Back
Top