looping over controls

[lxh]

I have a subform (Subform) within a form (Form). The subform holds a date control that records when a report has been received (RecdReport). The sub report is in datasheet mode (as the number of reports is on going). I need to be to display a pop up box if the report has not been received by the 1st of any given month.

I'm having problems finding and looping through each control (RecdReport) in the subreport. has anyone done this or know how to do it?

Many thanks
Lex

 

[Mile-O]

No need to loop through controls. Write a query that tests if your report is in. If it's not the the query's RecordCount shoule be 0. You can do a quick DCount, or something, to determine the Recordcount and act accordingly.

 

[lxh]

How would you do it?

Write a query that tests if your report is in. If it's not the the query's RecordCount shoule be 0. You can do a quick DCount, or something, to determine the Recordcount and act accordingly.

I have to admit that I don't really know how. I havw written queries before but this is more advanced than my normal stuff. I tried using the IIF() and Msgbox() functions but to no avail. Can you advise how?

Sorry and Thanks
Lex