How do i get predictive type in from a list in access

[Becs]

I have created tables of products and have linked to these on a form with
drop down boxes. I would like the user to be able to type a letter in the
cell and the list automatically display any product with that as a starting
letter, and if two letters are typed the list shows matching products
starting with those two letters etc. The IME sentance mode is set to Phrase
Predict but this still doesnt work. Any suggestions?

 

[fredg]

I have created tables of products and have linked to these on a form with
drop down boxes. I would like the user to be able to type a letter in the
cell and the list automatically display any product with that as a starting
letter, and if two letters are typed the list shows matching products
starting with those two letters etc. The IME sentance mode is set to Phrase
Predict but this still doesnt work. Any suggestions?

Sounds like a Combo Box with it's AutoExpand property set to Yes.

 

[Becs]

Its currently set on 'yes' but if i change it to 'no' it still doesnt work...

 

[Steve]

Create a query based on products table. Make the first column ProductName
and second column ProductID. Sort ProductName ascending. Open your form in
design view and select the combobox. Click on the Properties button. Go to
the Data tab. Set the row source property of your combobox to this query,
set Autoexpand to Yes and set BoundColumn to 2. Go to the Format tab. Set
Column Count to 2 and Column Width to 1.5;0. Go to the Event tab and put the
following code in the OnEnter event:
Me!NameOfYourCombobox.Dropdown

Now when your form is open, when you go to the combobox the list will
automatically drop down. Begin typing a product in and the list will
automatically scroll like you want.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)