Reports based on changable value

[scossar]

I have reports based on the value chosen in a combo box. The combo box values can be edited added to etc, but if a new option is added there is no report for this. Is there anyway to automatically create reports (based on a existing report) for any new options added.

Also is there anyway to create a link to the new report on the switchboard automatically or do you have to manually create new reports for any new option entered.

Any help would be appreciated.

Thanks

(If anyone requires any more info just ask)

 

[Pat Hartman]

Are all the reports the same except for their selection criteria? Why do you allow new entries to the combobox to be made by the user?

 

[scossar]

The reports are the same, except based on a specific query which has a (Like "xxxx")as the only differential. Layout, field headings etc on the reports are identical, only the actual report name/heading changes to show which option was chosen.

The reason for allowing users to enter variables into the combo is that at the moment the datatbase is at the start up phase, and being the first time I have attempted this I thought that it would be better to allow a degree of flexibility in the future. The combo box shows different types of clients/customers and although there is a set number of standard types there may be other new types in the future.

I hope this is what you were looking for.

 

[KKilfoil]

Is it always the SAME field that is filtered?

Why not set up a query with a parameter as the recordsource for the report. Then you only need 1 query no matter what the user selects. You can use a text field on your form, and reference it in your query in the criteria under the appropriate field to be filtered as follows:

[Forms]![frmYoutForm]![txtYourTextField]

 

[scossar]

thanks will give that a go

 

[kavarin]

KKilFoil seems to be on the money on this one. I had a similar question and the proven response was to build a query that is based on an unbound combo-box form I created. The user selects the appropriate value from that box and the query runs. Since you explained that all the fields are the same...KKilFoil's idea should work perfect