Hello Everyone
I would think there would be a simple solution, but after hours of searching I have not found one yet.
What I would like to do is have a form field (text box) auto populate a value depending on the selection of a combo box within the same form.
Example: Combo Box Selection is "Prospect " and Text Box value would auto populate to "Opportunity"
or: Combo Box Selection is "Client " and Text Box value would auto populate to "Clients"
The Combo Box is named "Contact_Type" and the Text Box is named "Category"
Basically I'm looking for an Expression or VBA Code that can do this, is this somehow possible? Any help would be greatly appreciated.
Thank You