Solved FILTER FORM BY DATE TEXTBOX (1 Viewer)

[georg0307]

Dear All,

I'd like to simply filter the form clicking button, based on date in FilterData TextBox.

I cannot find correct VBA expression.

 

[The_Doc_Man]

One way to do this is to apply a filter to the form via its .Filter property, then turn the filter ON and requery.

Form.Filter property (Access)

Office VBA reference topic

docs.microsoft.com

From the above link, you can see the .Filter and .FilterOn guidance.

Form.Requery method (Access)

Office VBA reference topic

docs.microsoft.com

The link includes a bullet item that expressly states that a Requery will take the Filter into account.

 

[bob fitz]

Try:
Me.Filter = "[PREVISIONE_ARRIVO_ INTERPORTO] = #" & Format(Me.FilterData, "dd\/mm\/yyyy") & "#"
OR:
Me.Filter = "[PREVISIONE_ARRIVO_ INTERPORTO] = #" & Format(Me.FilterData, "yyyy\/mm\/dd") & "#"

Rather than:
Me.Filter = "[PREVISIONE_ARRIVO_ INTERPORTO] = #" & Format(Me.FilterData, "gg\/mm\/aaaa") & "#"

 

[georg0307]

Great Bob!!! It works sorry for my ignorance, your suggestion works. Have a nice Life!!!

 

[bob fitz]

Great Bob!!! It works sorry for my ignorance, your suggestion works. Have a nice Life!!!

I'm glad it worked for you. Always pleased to help if I can.
Rest assured that you have No need to apologize for asking any question.
We all start knowing nothing and we all learn something along the way.