Lookup a record as you type in a form field

[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

 

[Marshall Barton]

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.

That's normal behavior for a combo box, what part of it are
you having trouble with?

 

[Bernie]

I feel like a fool, you are right.. indeed it is working
fine.

(I say as I hide because of my ignorance)