Filter function

[Jasp]

I want to create a filter function. The function should meet the following criterias.

- Able to filter on multiple table values
- Present filterresults in a listbox(in a form).
- Each record in the list should be able to click on and then open its specific record also that in a form.

Im not that experienced in VBA code or should i use queries for my purpose?

Any links to similar functions would be appriciated.

Thanks

 

[doulostheou]

Learning how to properly create queries and/or write SQL statements is really what you need. Access has many built in tools for handling filtering, and a custom function should not be necessary except in very specific instances.

I have written code that changes the source of a listbox (by filtering results) based on criteria supplied by the user, but it simply writes a custom SQL statement based on user supplied information to replace the source of the listbox. I would need more information on your particular situation in order to be able to offer any examples of actual code.