How can I insert specific data to report automatically (1 Viewer)

khodor

Member
Local time
Today, 17:59
Joined
Feb 2, 2021
Messages
39
Hello, I want to make a report with variables that are determined by "combobox" that is connected to a table that contains the name of the report and the date: from date 1 to date 2 . For example, if you set the first month through "combobox" the report automatically records that the report is titled "The First Month" And puts data that are between two dates only.
I actually associated the report with a variable to put data between [date1] and [date2]
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:59
Joined
May 7, 2009
Messages
19,169
you need to Create each Report
that you have on your table (name of report).
you only need the date1 and date2 field to
Filter your report.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 11:59
Joined
Feb 19, 2002
Messages
42,970
I don't see a question.

If you want to refer to controls on a form from a control on the report set the ControlsSource property to something like:

=Forms!yourform!yourcontrol

If you want to filter the report's RecordSource, create a query and ad a where clause that references the form fields

Select ...
From ...
Where SomeDate Between Forms!yourform!fromDT and Forms!yourform!thruDT

In both cases, the form must be open for the references to work.
 

Users who are viewing this thread

Top Bottom