In your table containing the English words, make another column containing the corresponding French words. Set the properties to display the French word when you select the English word from your drop-down menu. This is what I’ve done in one of my databases; When I select a generic drug name I display the trade name.
Thank you JuJu. I had already done that and that does work. The problem remains that I cannot get the french term to come up in a different field control, i.e., In drop down combo box in control #1, (which has the row source property set to a table containing both french and english terms as you indicated), I choose “knowledge”. How do I get the french term “connaisance” to display automatically in control #2 when I select “knowledge” in control #1?