I am trying to conduct a search through a fields in a table using Form Filter. I made a macro that's action is "DoMenuItem" and the command is "Filter by form". Every time I try to search for an object by typing in a value in a field (regular way and with wildcard characters), I never get results, even though those values exist. Can anyone tell me what I am doing wrong here? Also, is there any way to create a button on the form filter screen to hit instead of right clicking and hitting apply filter?
I am using excel 95 and thanks in advance.
Enrico
I am using excel 95 and thanks in advance.
Enrico
