Form Help

[bobo0605]

Hi,
Hope someone can help me with this problem. I created a form that has a drop down box and a start and end date. Also, on this form I have a command button. I would like when someone clicks the command button, a query would be created based on the info given. Also, a report would be automatically created.

 

[dhookom]

Based on the level of this question, I don't think you are ready for code that 'creates a report'. Most of the time, you have a report based on a record source and you want to filter the records displayed in the report. Is this your situation?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[glalsop]

I don't think that you really want to create a query and report on the fly, but just need to have them display dynamic data based on the form, right?

If that's the case then create your query and reference the form to filter your data:

[Forms]![YourFormName]![YourComboBox]

Then base your report on this query. When this is all running , you can use the DoCmd.OpenReport method to display the report when the user clicks the button on your form.

-Gary

 

[glalsop]

Sorry dhookum, I'm a slow typer...

-Gary

 

[bobo0605]

Thanks for the input. I will give it a try!!