Filter by Form does not work

[galantis]

Hi,
I have a form which I can't seem to filter by form. When I click on "Filter by Form", the only combo option I get is "Is Null" or "Is Not Null", it does not give the full list in the table to choose. Can anyone tell me what's wrong with my form? The form also has a sub-form....does it matter?

I also tried tesing filtering the table with query but it also doesn't work.
My query,
SELECT DOCUMENT.TITLE
FROM DOCUMENT
WHERE (((DOCUMENT.TITLE) ALike "*work order*"));


Also, with Filter by form can I use wildcards such as entering in the search field of the form as "= "*work order*"

thanks,
Galantis

 

[pafcpilgrim]

Galantis there is a small error in the SQL statement of your query when you tested it.

SELECT DOCUMENT.TITLE
FROM DOCUMENT
WHERE (((DOCUMENT.TITLE) ALike "*work order*"));

to do a wildcard search you just do ( Like "M*" ) you have an A infront of Like.