How do I filter A table?
Posted on 1998-05-02
I want to make a next button that will find the next occurance of whatever is in Edit1.text and only within the field as chosen in the combobox1.text.
I think what i need to do is set a bookmark then go to the bookmark, filter the data based on what was entered in the edit1.text then go to the next occurance then Free bookmark then un filter the table. e.g
Choose 'finder' from 'combobox1' (Finder is the name of the field I want to search) then enter 'mike' in the 'edit1' box (Mike is what I want to look for)
Press a 'Search' button which uses locate to find the first occurance of 'mike'(I have got this working no problem), if the first occurance is not what I am after the I can Press the 'Next' Button to go to the next occurance of 'Mike'.
I can not get the find next command or the filter to get its information from the Edit1 or the Combobox1 components.
Please help!!! Can you show me the code if possible.