conditional report loading based on query result

[brent78]

I am trying to create a form that when submitted it checks a query total result. If the result is 0 i want to load "rpt_1" otherwise I want it to load "rpt_2". I have everything setup, but I just don't know the syntax to get the result into the form to check it and compare it.

Thanks.

[puppydogbuddy]

I am trying to create a form that when submitted it checks a query total result. If the result is 0 i want to load "rpt_1" otherwise I want it to load "rpt_2". I have everything setup, but I just don't know the syntax to get the result into the form to check it and compare it.

Thanks.

1. Add a textbox control to the form, set its control source property ---> yourquery
2. I assume that your use of the word "submitted" means clicking a button. If so, then the code behind the button would be as follows:

Private Sub btnOpenRpt_Click()
If Me!MyTextbox.Value = 0 Then
      DoCmd.OpenReport "rept_1", acViewPreview
Else
      DoCmd.OpenReport "rept_2" , acViewPreview
End If
 

Replace yourquery and MyTexbox with the actual names of those objects in your application.