I need help creating a search field. What I'd like to create is a field that searches the same field in the table and if matches are found, allows the user to select and populate the field with that information.

I have created a data form allowing for entry into a co_individual table with subforms for a co_organization table and co_address table. When the user begins to type in the org_name field on the co_organization subform, I'd like the field to return a search of matched items from the org_name field so that the user can choose an org_name if one previously exists.

How would I go about this?



Thanks for any help you can provide!