searching form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, here I go. I would like to have a search form to display with just a few
fields from my Carrier Query (Carrier, Phone, Fax). I want the user to type
in a Carrier name and move through the Carrier Query finding a match. I
have set this up with a Combo box and created an event procedure in the
OnFocus event to come into the form with the combobox dropped down (Spinks'
suggestion). Is there a way to create this search form without the combobox
entry field? I have seen systems where you just type and it moves you
through the record - it does not actually have a field showing what you are
typing.

I will be opeing up a form with more details on the record when the user
selects the Carrier they want. How do I move to the record the user selected
in the new form I open?

Thank you in advance. You guys really know your stuff. I appreciate you
help.

Sarah
 
If you are saying you want to use a text box rather than a combo, but have
the text box do what a combo box does with the Auto Expand, then you could
use the Change event of the combo box. It fires after every keystroke. So
after every keystroke, you would have to execute a query and return the value
to the text box, and position the cursor at the end of the current text.

Seems like a lot of work for what a combo box does for free.
 
Back
Top