Filtering from touch buttons (1 Viewer)

A

anchamal

Registered User.

Local time

Yesterday, 22:45

Joined

Mar 7, 2010

Messages

57

• Sep 21, 2013

• #1

I'm using ms access 2013
i have a project where i need to create a touch screen jukebox.
my problem is that i have a textbox and a list box.
the list box has all my track and i'm filtering from the textbox.
when i use my keyboard the filter works fine from the textbox.
but when using the touch screen buttons even though letters appear on my textbox, the filter does not work.

any idea how to make my textbox filter work from the on screen touch buttons?
thanks

 

missinglinq

AWF VIP

Local time

Today, 01:45

Joined

Jun 20, 2003

Messages

6,423

• Sep 22, 2013

• #2

Where, exactly, is the code that performs the filtering? Normally this would either be in the AfterUpdate event of the Textbox used to enter the term to filter on or in the OnClick event of a Command Button, to be clicked after entering the term in the Textbox.

Linq ;0)>

 

A

anchamal

Registered User.

Local time

Yesterday, 22:45

Joined

Mar 7, 2010

Messages

57

• Sep 22, 2013

• #3

the command is in the textbox in the on change event.
me.txtfilter.requery

the command sent from my on screen button is:
If Me.btnGreek = True Then
Me.txtfilter = Me.txtfilter & "Α"


ElseIf Me.btnEnglish = True Then
Me.txtfilter = Me.txtfilter & "A"
End If

 

missinglinq

AWF VIP

Local time

Today, 01:45

Joined

Jun 20, 2003

Messages

6,423

• Sep 22, 2013

• #4

Since you're populating the txtFilter Control using code, the events associated with it, such as its OnChange event, will not fire; you have to explicitly CALL them. So:

Code:Copy to clipboard

If Me.btnGreek = True Then
  Me.txtfilter = Me.txtfilter & "Α"
  Call txtFilter_Change()
ElseIf Me.btnEnglish = True Then
  Me.txtfilter = Me.txtfilter & "A"
  Call txtFilter_Change()
End If

Is your intention to execute the same code, whether

btnGreek = True

or

btnEnglish = True

as the posted code shows?

Linq ;0)>

 

A

anchamal

Registered User.

Local time

Yesterday, 22:45

Joined

Mar 7, 2010

Messages

57

• Sep 22, 2013

• #5

the call command did the work
problem solved
thanks a lot

 

missinglinq

AWF VIP

Local time

Today, 01:45

Joined

Jun 20, 2003

Messages

6,423

• Sep 22, 2013

• #6

Glad we could help!

Linq ;0)>