Query to Form

[junction]

It's definitely there. Run the query and enter 21/12/10 as the date.

The table it is based on is tblPageNew, the actual SubForm is tblPage2 subform1

[RuralGuy]

What is the name of the SubFormControl that displays the SubForm?

[junction]

Sorry, I don't understand what you mean.

[RuralGuy]

I was looking at the wrong form, sorry.

[junction]

Have you had any luck?

[RuralGuy]

I got busy with other stuff and lost this thread. Thanks for the wake up call.

[junction]

Have you had any luck? (another wake up call!)

[RuralGuy]

Not yet but thanks for the additional wake up call. I have not given up yet. Just real busy with "stuff".

[reno]

Here is what I have done for a form I use (with SubForms), where I want to basically filter it through multiple queries. So I am always looking at the same form, just with different data depending on which 'Filter' button I click... (In Access 2003)

1. Copy the query used to create the form you wish to filter or run queries on.

2. Add criteria to the query to get the filter you want.

3. Open the form in design view.

4. Add a Command Button to the form. (cancel out of the wizard)

5. Right click on the button & go to Properties.

6. All tab.
a. In the “Name” section: Rename the button
b. In the “On Click” Section
i. Choose Event Procedure & click on the “…” to open the VB screen.


Type in this code (the blue will already be there, just add in the red code:
Private Sub ButtonName()
DoCmd.OpenForm "FormName”
Forms!FormName.RecordSource = "QueryName”
End Sub

Create multiple queries for all the different filters you would like to use & just repeat with new buttons.