Auto complete not working for lookup table

[Vandelay]

I have a field where the user is required to select from a list. In the current version, when you start typing (for instance 'tom'... it would complete it .. 'tomorrow'. I am revamping my database for '04 and I tried to do the same thing but this time it's not auto completing. One difference, and I'm not sure it matters. The table it's looking up has 2 columns, not just one like the current one has.

How can I make it auto - complete? I don't really see a setting for that.

 

[Onyxpurr]

The only thing I can think of is that maybe you're using a listbox instead of a combo box? A list box will not do the auto complete but a combo box will.

 

[JunglesMcBeef]

G'day,

May I ask how you got it to autocomplete in the first place?

 

[Vandelay]

It works now I think, I deleted the field and used the toolbox to intall a combo box, now it auto-completes. thanks