i have some problems building a report. this is a short example explaining the case:
I have a "Currency" table that stores currency rate values for a certain date. Another table is called "Payments". I need payments in local currency so I have to do calculations: [Payments].[Amount]*[Currency].[RateValue].
The problem is - when the [RateValue] field is empty I need to open a form for [RateValue] insertion. How can I open a form during report execution?
Originally posted by ivon
A report has events, just like a form or a control.
In your case, I guess I'd use the Open event.
but I want the Form open only when certain calculations are being made and Null value is used.
i.e. depending on query parameters I might not need the RateValue even though its value is Null in the table. Thus I want to trigger an even once RateValue is used in the calculations (described in the 1st post)
hope I'm clear with the case