How-To: Filter a List Box

[#1]

Hi,

I'm trying to filter a list box and I dont know how to.  I have a database with a large number of records.  I also have a report which is a subset of the records.  I have a list box which displays all of the NAMES from the large number of records.  I would like to filter the list box to only show NAMES that are in the report.

Can anyone help me.

Thanks,

Eamonn.

[#2]

Hi,

     You can use an expresion into list box to show the record subset.

I hope help you.

[#3]

Hi Gregorio Zerpa,

Thanks for your reply.

I have been trying to use the expression option but no luck so far.  I'm attaching a sample application which will show how I have tried to implement this.  It will illustrate what I have tried and maybe help you show me how I should correctly get the filter I'm looking for. 

I have inserted text on the app which should explain everything.

If you could have a look that would be great.

Thanks,

Eamonn.

[#4]

Hi Gregorio Zerpa,

Thanks for your reply.

I have been trying to use the expression option but no luck so far.  I'm attaching a sample application which will show how I have tried to implement this.  It will illustrate what I have tried and maybe help you show me how I should correctly get the filter I'm looking for. 

I have inserted text on the app which should explain everything.

If you could have a look that would be great.

Thanks,

Eamonn.

[#5 · Accepted solution]

Hi,

     Check listbox expresion.