Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    17

    Exclamation Unanswered: a form upon report execution???

    hi everyone,

    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?

    thanks
    Ali G is da best

  2. #2
    Join Date
    Nov 2002
    Posts
    272
    A report has events, just like a form or a control.
    In your case, I guess I'd use the Open event.

  3. #3
    Join Date
    Apr 2002
    Posts
    17
    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
    Ali G is da best

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •