unable to auto show up the item while using lookup

[Sogood]

any idea y my access unable to auto show up the item while using lookup ?

when a field using lookup it suppose to show the rest of the word , like

i type "S" it should show Singapore , why my access cannot ?

 

[namliam]

A combobox does just that

 

[Sogood]

A combobox does just that

i did ~ but still cannot , i can select from combo box but when i type the follow never show up

 

[namliam]

Check that your "auto expand" is set to yes in the properties of your combobox.

 

[Sogood]

Check that your "auto expand" is set to yes in the properties of your combobox.

errrrrrrrr......

here is what happen for me :

1. i create a table in database "one" with ID and name
i set the name lookup combobox itself
it work fine ,lookup by clicking the downarrow and expand work fine

2. i create another database "two" and drag the table from "one" as copy
then the lookup function still available but it won't auto expand any more

 

[boblarson]

errrrrrrrr......

here is what happen for me :

1. i create a table in database "one" with ID and name
i set the name lookup combobox itself
it work fine ,lookup by clicking the downarrow and expand work fine

2. i create another database "two" and drag the table from "one" as copy
then the lookup function still available but it won't auto expand any more

NO, NO, NO! Do NOT use lookups at TABLE level. You use them on FORMS not in tables. While the ability to do it in tables exists, it is a bad thing to try to use. See here for more about that:
Evils of Lookups in Tables

You use a combo box on a FORM that has the table (or preferably a query of the table) as its recordsource.