User selecting multiple selections from listbox

[n1ef5ng1]

Hi,

Attached is for the data.

Data is a list of ports in the world. (sample size).

Port_Code refers to each of the port (primary port)

Group_Port_Code are the list of port from port code that can be group under one.

i.e THBKK (Group_Port_Code) consist of multiple port code such as THTPT THUCT...

on the list box below,I would like to combine Group Port Code and Port Code together in one listbox. Hence i came out with this code,

if(isNull(Group_Port_Code),Port_Code,Group_Port_Code)

This code would make the group port n port code together in one list.

Here is the qn, as there are many port in the world (like 500), it will be daunting for user to select the list of port in drop down form,

there is this where user can type like THBKK (Space) AOLAD to choose the port. however i realize it doesn work when there is coding involved in the listbox

anybody can help. thanks

[morganaaron]

So you want them to be able to type the Group Code then the Port Code in the same string and to find the Port? In order to do that, you'd need the listbox to be a combination of the two codes (Group_Port_Code & ' ' & Port_Code) - if you then got them to type including wildcards, *THBKK THP* for example would give them the option of the port code that is under that group port code.

Apologies if I've misunderstood!