de

[sue]

I have a contacts table with firstname and lastname fields along with
address
phone etc.
I have a form to enter contacts information. Can the form open matching
record as I type in the first and last name rather than creating a new
record
and than just update the existing one?

 

[John W. Vinson]

I have a contacts table with firstname and lastname fields along with
address
phone etc.
I have a form to enter contacts information. Can the form open matching
record as I type in the first and last name rather than creating a new
record
and than just update the existing one?

About the simplest way to do this would be to put a Combo Box on the form,
displaying the full name (concatenating the first and lastname fields); use
the toolbox wizard option "use this combo to find a record".

 

[Tom Wickerath]

Hi Sue,

To add some to John's answer, here is a tutorial that I wrote that shows how
to implement his suggestion:

Combo box to find a record
http://www.access.qbuilt.com/html/find_a_record.html

Also, Access MVP Arvin Meyer has a sample you might want to look at:
http://www.datastrat.com/Download/ExpandingSearch2K.zip

Access MVP Allen Browne has a sample as well:
http://allenbrowne.com/ser-62.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________