Autoupdate a field based on another field

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

 

[Danny Seager]

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]

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 -

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?

 

[Danny Seager]

It will go in the control source of the text box where you want to display
the looked up data