sorry for double posting but am i correct in the statement that filter by form does not work in runtime. i have come to that conclusion as i have gotten it added as a button but when i click on it, it does nothing.
no subforms and it does work in normal accdb. just not when i open as runtime. im fairly sure that's a runtime shortcoming. kind of a shame, the fbf is easier for less technical people to figure out and get doing custom filters.
Tis a shame. Ensure that the "Allow Filters" property of the form is set to Yes as well. You will find this on the data tab. Then run it and see the outcome.
You could implement a few text boxes/combo boxes (say 4 or so) for filtering the most relevant fields in your form.
