why no one wanna help me?

[AND]

It's the second time I post a question in 3 days but.. why no one can help
me? is my issue impossible?

I have a sheet imported form excel, named "data"; here the column:
w2cose, w2ctr, w2core,, w2dcom, w2ggina, w2ggouta, abest, w2ucote, Ore
lavorate, oltre_le_8, HF, serata

I've created a form(FORM1) with a subform(SUBFORM_DATA).

I need OF 12 textbox in "form1", where each textbox filters the value of
abest column of "subform Data" when I click "button1"

I can't solve this question. can you help me please???
thanks to all will help me.

 

[Tom van Stiphout]

On Fri, 13 Mar 2009 17:04:01 -0700, AND

You can set the Filter property of the subform to an expression
similar to a WHERE clause. For example:
dim strFilter as string
strFilter = "FirstName='" & Me.txtFirstName & "' AND LastName='" &
Me.txtLastName & "'"
Me.mySubformControl.Form.Filter = strFilter
Me.mySubformControl.Form.FilterOn

Note how I wrapped string values like FirstName in single-quotes.
Numeric values don't need this.
Can you apply this example to your situation?

-Tom.
Microsoft Access MVP

 

[AND]

yes, I think it's so.
thank u very much.
I'm going to run it. I'll give u feedback.
thanks again.

 

[AND]

hi Tom,
I can't run it. maybe I was wrong to fill in the data. what do you think
about?

Private Sub Comando17_Click()
Dim strFilter As String

'abest=the value in subform to filter on; testo16 and testo17= 2 textbox
strFilter = "[abest]='" & Testo16 & "' AND LastName='" & Me.Testo17 & "'"

'[Sottomaschera STAMPA_INTERNAZ]= the subform
Me.[Sottomaschera STAMPA_INTERNAZ].Form.Filter = strFilter
Me.[Sottomaschera STAMPA_INTERNAZ].Form.FilterOn

End Sub

thank a lot.

 

[Tom van Stiphout]

On Fri, 13 Mar 2009 19:58:01 -0700, AND

LastName???

-Tom.