Determine the existence of a record being added

[Cedarguy]

I have a table called FAMILY which is at the top of the relationship chain. When I add a new FAMILY via the form associated with it, I need to determine that the family doesn't already exist. Which control can I use (and how) on say the NAME field, that would list for me all the names that match the partial entry I make. For instance, if I'm adding David Brown and enter "Da", all names starting with "Da" should be listed so I can visually verify whether or not David Brown exists in the table.



I know all this is a lot to ask but I'm also certain that this is nothing new, so if I can be referred to an existing example, that would be awesome.

Thanks

[June7]

Review:
http://datapigtechnologies.com/flash...tomfilter.html
https://www.accessforums.net/showthr...other-criteria

Shouldn't user try search on lastname anyway? Could have a combobox with a RecordSource like:
SELECT LastName & ", " & FirstName FROM tablename ORDER BY LastName, FirstName;

Then with AutoExpand property as Yes the field will automatically display matching names, if any, as the user types.

[Missinglinq]

Allen Browne has a hack to give a Textbox Control an AutoExpand-like function

http://allenbrowne.com/AppFindAsUType.html

but as June7 suggested, why not use the native AutoExpand function of a Combobox for this task?

As a rule

Reinventing the wheel = Spinning one's wheels

Linq ;0)>

[Cedarguy]

Thank you June7 and Missinglinq; you have given me enough to chew on; regards