Contact Finder

E

Emine

I created a form where when you use a Filter (used a dropdown) and when user
starts typing the value it automatically starts populating that value in my
search results. Is there a way once the populated value is found in my
search results, I can have the user click on that value so that the user can
go directly to that record to edit the record? Right now the way it works it
only shows what is in the database and not very useful for editing records
once its been found.

What do I need to do? Can someone please help me?
 
A

Al Campagna

Emine,
Not sure I understand but...
Use the AfterUpdate event of the combo to initiate the search. This
would trigger whether you let Auto Expand find the correct record, or simply
type in the complete value yourself.
On my website below, I have a 97 and 2003 sample file called Quick Find
Combo. It demonstrates how to go to a unique record for editing.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Top