combo lookup

[LoneReaper]

i have a simple db that i am using for data entry i have a table that lists the product sku, book isbn, book condition, and notes.

the book condition field looks at another table that has like 5 records to choose from

1 Used Like New
2 Used Very Good etc...

when i am in the field i just type 2 and it selects the second option and enters the text

"2 Used Very Good"

into the field. My Notes field does not start off with numbers, it has a key field though.

Here is the question. How can i get the notes field so that i type "in a number like 2", it opens a drop down list that shows some options like

"Book is in New Conditon with minimal wear"
"Book is in New Condition with some highlighting"

and picks the corresponding option in the list, and fills in the notes field with "Book is in New Condition with some highlighting"

 

[dan-cat]

Here is an example for you.

Note that the notes combo field is requeried on its onenter event

 

[LoneReaper]

not quite

thank you but that isnt really what i was look for. Take a look at this excel file, Look at sheet Sample fill in

column E has a drop down list and when you start to type a laetter of an option it auto fills the field. instead of the letters i would like to type the number that represents the record

ie: if i typed 3 the field would auto fill with the third listed option which is "Very good condition, minor wear" and of course i am talking about using access to do this.