Popup Menus

[gavjb]

I am trying to create a Popup Menu for some of my forms, but I cant seem to find one function I want to add on to the Popup.

On the Default Popup you have an option called "Filter For" and then a box where you can enter the filter condition, does anyone know how I can add this to my own Popup and what it is called and where it is located.

I have tried all the Filters under Records when creating my Popup, but none have this feature.

Thanks,


Gavin,

 

[AccessGuruCarl]

gavjb,

To the best of my knowledge, If you don't want the default filters access offers you from the toolbars, then you'll need to create SQL statements based on what you'd like to filter.

Populate your drop-down menu with the choices, then when the user clicks use the openargs to pass an argument to the form. When the form opens run the SQL based on the option.

Hope this helps....

AccessGuruCarl
Programmers helping programmers
you can't find a better site.