hope it`s simple

[Ron]

I have a query that get the criteria from form1
On form1 I have a command button that open a second form (Chatform)with a
chart that applies to the data from query.
when query returns with no data Chartform open with blank chart.
Instead I would like to have counter that if it will be 0 then I`ll get
message "No data, can not create the chart"

Please help,

Thanks

 

[Guest]

You could use the DCount function using the same criteria you use for the
query that builds the chart and only open the form if there is data:

If DCount("*","QueryOrTableName", "Same Criteria Here") = 0 Then
MsgBox "No Data Available For Chart"
Else
DoCms.OpenForm....
End If

 

[Ron]

Thanks, works just fine.

You could use the DCount function using the same criteria you use for the
query that builds the chart and only open the form if there is data:

If DCount("*","QueryOrTableName", "Same Criteria Here") = 0 Then
MsgBox "No Data Available For Chart"
Else
DoCms.OpenForm....
End If

 

[Marshall Barton]

Since the query supposedly refers to form controls for its
parameters, there is no additional criteria to use in the
DCount. Just using:
DCount("*", "QueryOrTableName")
should be all that's needed.