Return different values in "text box2" based on value of "text box1"

Jeff,

Thank you once again for your expert help.

Not knowing how to work with modules, I had simply added the new module
in the main database window.

I found that what I needed to do was to open the form in design view,
click the "Code" icon on the toolbar, then type in the GetBMIComment
module code as you recommended.

The form now works perfectly.

Jon