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?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question