How to filter a repor with a textbox value on the report

[King JOT]

I have a report which is based on a querry i created in access. The report has a date field. on the report, I have two text boxes labled "FROM" and "TO" respectively. and the a button labled "FILTER".
I want the report to show only records which date field falls within the date value "FROM" textbox and the "TO" textbox

[twinnyfo]

King JOT,

If I understand your question properly, the following code, initiated by clicking the Filter button should work:

Option Compare Database
Option Explicit
 
Private Sub cmdFilter_Click()
On Error GoTo EH
    Me.Filter = "Date >= #" & Me.txtFROM & _
        "# AND Date <= #" & Me.txtTO & "#"
    Me.FilterOn = True
    Exit Sub
EH:
    MsgBox Err.Number & " " & Err.Description
End Sub
 

Please let me know if this helps.

[zmbd]

Why are you doing the filter in the report?
Create a form with the from and to dates in two text fields and a button to run the report.
You can use some VBA to validate the dates
Then use a parameter based query refering back to the form as the record source for your report.
When you open the report, the form will open, user enters the dates and the report runs...
I use the onclose event of the report to close the form.

Step by Step example is here:
http://office.microsoft.com/en-us/ac...001117077.aspx

-z

[zmbd]

Moderator's Note:
Do to a recent round of unrelated posts to this thread, any further posts to this thread need to be in direct address to King JOT original post or provide some additional helpful information such as a new feature, or one that was overlooked.

Other non-related posts will be removed and treated as spam/thread-hijack.

-Z