Sub form with calender

[phillbaker]

i have a sub form with a calender on it and you enter a start and end date and then it runs a query between those two dates and opens a report.

I want to have another form to also open up so they can select to only show the results for particualr clients.

is there a easy way to do this.

 

[dkinley]

One suggestion might be to have a form populated by the query that runs between those two dates. You could show this form in datasheet view. The user could select a specific record and then open the regular form for that record.

I personally use the double-click event to open a form in this method. I consistently choose the first control in the datasheet view to add code to the double-click. Open form, form name, where the primary key ID is equal to the ID of the record I am on.

I say all of this because I am interpreting that the basis of running this query between dates is to filter the quantity of returns based on a date instead of a name or something.

-dk

 

[phillbaker]

yes you would be correct in what i am trying to do. But i was hoping to select the dates first then press a button and select the people i wanted to filter out.

 

[dkinley]

Not sure I am quite getting it. Once the list comes up you want to delete people off the list singularly?

If not, I've attached what I thought you were looking for. Look at the fSearch form (fTable is the form for individual records).

-dK

 

[phillbaker]

the start and end bit is what i have so thats correct once you hit the bottom i want it to load a form where i can select clients and then it load a report showing for those clients details for between those two dates

 

[dkinley]

In the demo I posted, you can adjust the double-click action and instead of opening a form, open a report for that particular record.

If you want to open a report that has details for all of those records just set a command button to open the report you created and the underlying data source for the report is that query.

But now what I think you want to do is to now look at the list that is returned, select 1 or more records and send those records to the report?

-dK