combo box and reports

[ainaphillips]

Hello I need some help.
I have a form that has 2 combo box. i want to use the inof in the combo
bok to run a report. How do i relate this form with the report.
If anyone can please help me i can send you the database so you could
have a visual of what i am talking about.
Thanks
ap

 

[Larry Linson]

I have a form that has 2 combo box. i want
to use the inof in the combo box to run a
report. How do i relate this form with the
report.

If you are conversant in Access' VBA, you can use the information selected
by the user in the Combo Boxes to create a DoCmd.OpenReport statement.
There is good Help on DoCmd.OpenReport -- in a module window, put the cursor
on OpenReport, then press F1. You can let the user select the Report, or
information that you use to construct either the WhereCondition argument of
DoCmd.OpenReport or to modify the RecordSource of the Report to select
particular information (e.g., date ranges) to be displayed.

If we'd had some detailed information on what you have and what you want to
accomplish, someone could likely have given you a more detailed suggestion.

If anyone can please help me i can send you
the database so you could have a visual of
what i am talking about.

Please understand this is not personal, but there are so many malicious
users on the Internet, and malicious posters in newsgroups, these days, that
not many people will accept and run a database from someone they do not
know.

Larry Linson
Microsoft Access MVP