3 Reports with 1 Query

[peshonzi]

Hello.



I've created a form that has two subforms . Each of them wants me to input a date, that is the same for the three of them.

So, the question is:

How to create a query that inputs three similar dates in three different forms ?

[apr pillai]

1. Create a temporary table with a Date Field and with a single record.
2. Place the Table on the Query and use the Date Field as criteria.
3. All you have to do is to change the Date on the parameter table.
4. Design a small Form on the parameter table with a Command Button to launch the Main Form.
5. After setting the new date Click on the Command Button to Open the Main form with the Sub-Forms.

Sample code for Opening the Form:

Private Sub cmdOpen_Click()
     Docmd.OpenForm "Main", acNormal
End Sub

[peshonzi]

That's a smart way, but unfortunately, it doesn't work.

Probably I don't have the right SQL code... which I even don'y know how to write...

PLEASE HELP ME !

[peshonzi]

see this -> https://www.accessforums.net/access/...ria-14892.html