Autocomplete as you type on table

[calvinle]

Hi,

I don't know if it's doable, but I have a table to enter the last name and first name which I will insert into my main form that will become a subform.

When the first record is entered as example: RICHARD
When on the second record, when typing R, it will appears RICHARD as choice.

I know how to do in combobox, but I want to directly implement that into the first column itself.

Can anyone help?

Thanks

 

[burrina]

Forms are for entering data, not tables. Yes, there is utility you can get from Allen Browne for this via a form.

 

[calvinle]

The data can can also be entered into subform isnt it?