Search results

I have a report (rptStudy) which a user can filter by means of several text boxes in a form (frmSearch). The filter criteria is entered into the form which then opens the report, applies the filter, and closes the form. Works great. Here is my problem: I would like to have a command button on...

Ok, I see. But this is in my query. I need it to be in my Search form as the date range will be entered by the user and change each time

David, Thanks for the speedy reply. The problem for me is that I am such a beginner with this that I need to see an example of what that means. Sorry! But if you don't mind giving me the time, then what would the code look like that I need to put in? Thanks for your patience! Mark

I am working with a form called frmSearch that filters a report called rptStudies. I am already filtering two fields [Book] and [Chapter] successfully with the following code: ________ Private Sub cmdFilter_Click() Dim strFilter As String ' Build criteria string for...

Thanks all, good points. But I've gone with the following that seems to do what I need: Private Sub cmdFilter_Click() Dim strFilter As String ' Build criteria string for searching by Book If IsNull(Me.cbobook.Value) = False Then strFilter = "([Book]='" & Me.cbobook.Value & "' Or...

Not quite I'm afraid... with that code change I still have the same problem in that if I leave a field blank in the Search form the report gives me all records for that field except any that are blank themselves! I'm pretty sure that the part of the code that needs to change is the Like...

I am very new to access 2007 and struggling with the code for a form named frmSearch that I am using to filter a report named rptBibleStudies. There are two frames on the form which each filter one of the following fields: [Book] and [Chapter]. If the field is left blank in the frmSearch...