Lookup a record as you type in a form field

  • Thread starter Thread starter Bernie
  • Start date Start date
B

Bernie

Hope this makes sense:

I have a form with a combo box (customers) from a
table 'tblorders'. In 'tblorders' I have lookup based on a
query which queries "tblcustomers' and the name
field 'customername' . How can I make it so that when I
create a new record using my form ('frmorder") , and enter
the "customer" field I type a letter into the field it
moves my down to that letter. I.e. I enter the
field "customer", type in "h" then "a" that it moves me
down to .. Let's say "Hammer" I can then use the dropdown
to scroll to Hampton and select that customer.

TIA for any advice

Bernie
 
Bernie said:
I have a form with a combo box (customers) from a
table 'tblorders'. In 'tblorders' I have lookup based on a
query which queries "tblcustomers' and the name
field 'customername' . How can I make it so that when I
create a new record using my form ('frmorder") , and enter
the "customer" field I type a letter into the field it
moves my down to that letter. I.e. I enter the
field "customer", type in "h" then "a" that it moves me
down to .. Let's say "Hammer" I can then use the dropdown
to scroll to Hampton and select that customer.
Click to expand...


That's normal behavior for a combo box, what part of it are
you having trouble with?
 
I feel like a fool, you are right.. indeed it is working
fine.

(I say as I hide because of my ignorance)
 
Back
Top