I have a form that has a "from date" you fill in and a "to date" as well as a "company section".When you hit the button it opens a report that is bound to a query.In the report properties under Format_Details Event, I loop through the records and do some calculations and fill those results in unbound text boxes on the report. This works great until I select a company section on the form that has no records for the dates that I picked. It says that the expression I created in the Format_Details Events have no value because there is no records being passed in the query. I tried to trap this with the No_Data Event on the report but was unable to get it to work. Can anyone help and tell me how you deal with a report bound to a query when the query is not receiving any records.
