Combo box |search value| auto-fill textbox

[Mr.Karr]

Hello

Can anyone please provide a code snippet for the below;

1. Combox1: using the dropdown, select & search for the particular line from the data
2. Textbox1,2,3: auto-fill value using offset and populate

In detail: This activity helps users to save time by finding available details by default and populate in other fields.

Please see the attached file.

Thanks in advance

 

[Hui]

See attached

Note the use of Named formula to transfer data as well as load the Combobox

 

[Mr.Karr]

@Hui thanks. This works like a breeze!

 

[Mr.Karr]

@Hui: a quick question and seeking your help.
In case, can we able to modify the existing code a bit to accommodate, previous and next matching record.

Please see the attached file