Search for similar items in table field

[abbottboi]

Hi,

I have a form with a frist_name field. I want the field to auto search the first_name field in the table when you type in someones name. Meaning, to look up existing records with the same name to avoid duplicates.

Is there a way to search through the table field automatically while typing the the form field?

thanks

 

[Remou]

Have you looked at combo boxes?

 

[TheAceMan1]

How are ya abbottboi . . .

Have a look at the [blue]DLookUp[/blue] function . . .

See Ya! . . . . . .