Report Parameter Queries help 1

[Lostsouljer]

I Have created a report that is obtaining its parameters from a form, which in turn then runs a query, the problem i am having is that after you enter the parameters into the form (a start date and end date), two text boxes pop up asking you to enter the startdate and enddate for the query (which is exactly the same as what has just been entered for the form. I can see the query has already been run from the parameters from the form as it pops up in the background with all the appropriate information, yet it is still asking me to re enter in the parameters) What am i doing wrong??Below is the code that i got off the Microsoft website help.

This is the code i am using for the query

Between [Forms]![Sort by workshop date]![StartDate] And [Sort by workshop date]![EndDate]


This is the code for the Form

Private Sub cmdOk_Click()

Me.Visible = False
DoCmd.OpenQuery "Appointments period", acViewNormal, acEdit
DoCmd.Close acForm, "Sort by workshop date"
End Sub



and this is in the report

Private Sub Report_Close()
DoCmd.Close acForm, "Sort by workshop date"
End Sub

Private Sub Report_Open(Cancel As Integer)
' Set public variable to true to indicate that the report
' is in the Open event
bInReportOpenEvent = True

' Open Sales By Category Dialog
DoCmd.OpenForm "Sort by workshop date", , , , , acDialog

' Cancel Report if User Clicked the Cancel Button
' If IsLoaded("Sort by workshop date") = False Then Cancel = True

' Set public variable to false to indicate that the
' Open event is completed
bInReportOpenEvent = False
End Sub



Any help would be greatly appreciated

 

[dhookom]

Why are you including these two lines of code:

  DoCmd.OpenQuery "Appointments period", acViewNormal, acEdit
  DoCmd.Close acForm, "Sort by workshop date"

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]

 

[Lostsouljer]

I have been using this page

http://office.microsoft.com/en-au/assistance/HA011170771033.aspx

as a guide, from what i can understand, it opens up the query that i have named Appointments Period and then closes the form

 

[dhookom]

The article first talks about opening a query and later talks about opening a report. I don't think the author meant for you to open the query if all you want is to open the report. Just comment out the two lines I asked about and run your application.

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]

 

[Lostsouljer]

I have tried what you suggested. It still opens the form to let me input the paramaters but i then get this pop up box asking for the parameters again?? Im at a loss to what is wrong. Thank you for your help so far though

Brendon

 

[Lostsouljer]

I dont know how to edit posts in this forum but the writing in that box is part of my query (it has two pop up boxes, one for the start date and one for the end date)

 

[dhookom]

What is your relevant code? Are you closing the form anywhere? If so, comment out the code.

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]

 

[Lostsouljer]

I commented out the form closing code but am still having the same problem. I found the thread below and it is working for me so i will try and do it that way. Thank you for all your help though, its greatly appreciated

Brendon

http://www.tek-tips.com/viewthread.cfm?qid=1175691&page=1