Auto-Complete on a text field using a Table

[Guest_imported]

I am attempting to make a field autocomplete as the user enters information, past entries into the same field will appear. Like, Excel does for autocomplete down a column.

For instance, I have a table and it has three records and in the LastName field their are three different values:
Roberts
Robertson
Robertsen

Now, when the user begins to type the database is queries for like values.

 

[Guest_imported]

When the users enters "R", Roberts is display. The user continues to press keys and gets to "Robertso" and Robertson is displayed.

 

[PantoKing]

Hello,

It may be easier to use a Combo Box rather than a text box to do what you are trying to do. Ensure that you have the autoexpand property set to yes and this should do the job.

HTH.

Steve.