Bounded Text box with Find capabilites
Bounded Text box with Find capabilites
(OP)
How can I make a bounded text box, able to act as a searchable string. (e.g. I have a text box that displays a test name, I would like to be able to enter a new test name and <ENTER> to search for the next occurrence of matching characters, without adding a find button from the tool bar)
RE: Bounded Text box with Find capabilites
If however, you create a text box that is unbound, you can write code, maybe in the AfterUpdate event, to do your searching for you.
Does that sound like what you want to do?
Kathryn
RE: Bounded Text box with Find capabilites
If you want to have a searchable form, have an UNBOUND text box for your criteria. Then after update of the field you can:
1) Create a dynamic SQL string based on your criteria,
2) Set your forms Record Source to that string, and
3) Refresh your form.
This is just one way that I like to use, I am sure others may have some methods they prefer. If you need help with the SQL statement, let us know.
Jim Lunde
compugeeks@hotmail.com
CompuGEEKS
Custom Application Development