Intelli-sense? Show previous entered,as I type?

THREE05

Registered User.
Local time
Today, 13:23
Joined
Dec 29, 2015
Messages
30
If I enter in my input form as customer "Napolitan Peter"and then later I enter a new order for that same customer. I wonder if there is a code for my customer name field to pull or show me the previous entered so I can click on it and autofill? exel does that....do I make sense? Thank you in advance my good friends. :confused:
 
You could in the Before update event, set the default value to that of the text.
Maybe.
 
I don't know of any code that does that but I think you could write some code to accomplish that. I've attached a simple database that filters as you type. Maybe you could start with this simple code and when the match is complete have the code populate the rest of your form fields with the matching records fields.
 

Attachments

Private Sub txtCustomer_AfterUpdate()
Me.txtCustomer.DefaultValue = Me.txtCustomer
End Sub
 
Thanks a lot buddy! I definitely try it out... Blessings......
 

Users who are viewing this thread

Back
Top Bottom