Lookup a value in a table and display text if a value exists

[Tim Gallivan]

I have a customer database form named frmMain with a field called txtAgency.

I also have a table that has a column of agency codes that are in the
Outlook Global directory. The table is called tbl_Global and consist of about
40 records.

If the user inputs an agency that is within this table on the frmMain, I
want the phone number field (txtPhone) on the database form to automatically
display "See Outlook". If the agency is not within this list, I want the end
user to be able input a value on the form.

What is the best way to go about this?

 

[Allen Browne]

Use DLookup() to get the phone number of the selected agency.

See:
http://allenbrowne.com/casu-07.html