Filter By Form Alternative for Runtime versions?

[Guest]

I have developed an app that uses "filter by Form" on a custom toolbar. Only
late in the game did I discover that this would not function when
distributing using Access runtime.

Is there any workaround this? .. or an alternative method of searching for
records (other than a combo box)

Any help greatly appreciated.

Thanks in advance.

Ray Hallock

 

[Allen Browne]

Ray, what I generally do is to place some extra controls in the Form Header
for the fields the user is most likely going to search on. They can then
enter criteria in any combination of these unbound controls, and click a
command button to apply the filter.

Here's an example of what it looks like, and you can download the sample to
see how the code works:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
Most of my forms have these controls in the form header (unless they only
need one combo to jump to the record.) The interface is obvious yet not too
intrusive.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


news:[email protected]...

 

[Guest]

Thanks Allan,

With a little tweaking I got your code to work for me and then pass the
result to another detail form.

Ray