Hello everyone,
Using Access =9203=85
I have a Form in which users search for data in an underlying Table by
means of a textbox. Users can type or =93scan=94 a jacket number into the
textbox and click a command button that does the search.
The aforementioned works fine, but I=92d like the search to begin after
the jacket number is entered without having to click the command
button. In my environment, users can quickly scan a number into the
database with a hand scanner; having to then grab the mouse or
keyboard can be ***bersome.
The jacket numbers are either 6 or 8 characters long. I wasn=92t sure
if there was a way to code the form to execute its query (it performs
a make table) after the character string (might be hard since there
can be two lengths) or some other way to recognize/predict when to
start the query. The Form will not see 6 character jacket numbers too
often, so we could code just the 8 character jacket.
Thoughts?
alex
