How to create Advanced Reports in Access 2000?

[murphy123]

How can I create one report that would select/pull data from several other forms, that would include drop down boxes, check boxes, etc., to come with one report result using just one query?

 

[dhookom]

Normally you place values into tables and use reports with controls and/or subreports to display the values from the tables. You can also use code to retrieve values and set control sources.

To display a value from a combo box on a form in your report, the syntax would be like:

=Forms!frmYourForm!cboYourComboBoxName

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]