Populate automatically a textbox based on value within a Combobox on a form

Hello,

I need some help from the experts please. I appreciate that 1 form.PNGmy question has already been raised several times but I could not find the real code that would make my project work. Hence my request for help from you.

The objective: I would like to be able to auto-populate the 'Assigned to' field with the corresponding value as soon as the field 'Supplier Name' is selected on the Supplier Details section of the form, which is dependent on the 'Product or service' field on the Lead Details section of the form.

The issue: I managed to find a way to work out the procedure from 'Product or Service' to 'Supplier Name' without a big issue. And every time I change the value of 'Product or Service' automatically 'Supplier Name' changes to corresponding options.
However, the code doesn't necessarily work when it comes to 'Assigned to' procedure because as soon as it assign one value, that value will also stays there although I selected different value from either 'Supplier Name' or 'Product or Service'.
The problem here is that, let's suppose the value selected in the field 'Supplier Name' was incorrect. If I then change that value to the correct one, 'Assigned to' field will retain the previous value allocated there from the incorrect value of 'Supplier Name'

Possible Solution: I assume, I should clear that field every time the value of 'Supplier Name' changes but unsure how to do that. Also, I'm sure there is a better way to execute this event from a simpler code, though this is only an assumption.

Any help from you is greatly appreciated. Thank you very much

Please Login or Register  to view this content.

Thank you Mehmetcik for your contribution

I've used your suggestion but the auto-fill wasn't working on the TextBox24. Actually nothing is showing at all after you selected the proper value in the ComboBox12. May be I have missed something in replicating it.

Best,

Anyone may be able to look at this and provide some help please. Much appreciated.

Hello, I have managed to work it a bit more but not very satisfied with the result. Somehow, the name Barry populates the field TextBox when no selection is on both ComboBoxes.

Please Login or Register  to view this content.

i need file demo, thanks