hope it`s simple

R

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
 
K

Klatuu

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
 
R

Ron

Thanks, works just fine.
Klatuu said:
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
Click to expand...
 
M

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.
 
Top