Finding record to update in an updating form

fvreg

Registered User.
Local time
Today, 13:34
Joined
Sep 15, 2005
Messages
15
I have a form in which old customers can be edited and new customers can be added.
Currently, to edit a customer, the user clicks in the "Last Name" field and then selects EDIT-FIND and types in the last name. The user will then cycle through all customers with that name to select the correct one.
How do I allow a user to begin typing in the last name field and have the name appear? Is there an easier way to do this?

Many thanks.
 
You could consider a double click event to change the field from an edit into a search. On the double click event hide the text field and in its place display and set the focus to a previously hidden combo. On a change from this value populate the form.
 
That sounds something like what I need to accomplish. Unfortunately, as an Access beginner, it seems to be a little over my head.
 

Users who are viewing this thread

Back
Top Bottom