CrystalSurfer
Matrix activist
- Local time
- Today, 10:53
- Joined
- Jan 11, 2006
- Messages
- 75
Can a textbox be put on a single (record) form and be used as a search filter for that same form?
ie: I want to have a customer name textbox to filter for those matching (partial) customer names on the same form (bound to the Customer table) that the textbox is on.
eg: I fire up the form that displays the first record of 726. I then type in "O" in the search box which will then display the first record of 487, then add a "l" which displays the first record of 121, then add a "d" which displays the first record of 14, and so on..
Is there a problem with that? and if not, what coding would you suggest?
I've seached the forum, played with all the examples (which seem to be built around filtering a continuous form) and still have not managed to get it working.
ie: I want to have a customer name textbox to filter for those matching (partial) customer names on the same form (bound to the Customer table) that the textbox is on.
eg: I fire up the form that displays the first record of 726. I then type in "O" in the search box which will then display the first record of 487, then add a "l" which displays the first record of 121, then add a "d" which displays the first record of 14, and so on..
Is there a problem with that? and if not, what coding would you suggest?
I've seached the forum, played with all the examples (which seem to be built around filtering a continuous form) and still have not managed to get it working.
