Intelli-sense? Show previous entered,as I type? (1 Viewer)

T

THREE05

Registered User.

Local time

Today, 15:59

Joined

Dec 29, 2015

Messages

30

• Jan 5, 2016

• #1

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.

 

Ranman256

Well-known member

Local time

Today, 18:59

Joined

Apr 9, 2015

Messages

4,339

• Jan 5, 2016

• #2

You could in the Before update event, set the default value to that of the text.
Maybe.

 

S

sneuberg

AWF VIP

Local time

Today, 15:59

Joined

Oct 17, 2014

Messages

3,506

• Jan 5, 2016

• #3

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

• FilterOnChange.zip

  55.6 KB · Views: 44

Cronk

Registered User.

Local time

Tomorrow, 08:59

Joined

Jul 4, 2013

Messages

2,771

• Jan 5, 2016

• #4

Private Sub txtCustomer_AfterUpdate()
Me.txtCustomer.DefaultValue = Me.txtCustomer
End Sub

 

T

THREE05

Registered User.

Local time

Today, 15:59

Joined

Dec 29, 2015

Messages

30

• Jan 6, 2016

• #5

Thanks a lot buddy! I definitely try it out... Blessings......