first Procedure, next Query and then display report.

Question

Hello,

Work Done: I wrote a procedure PrcA to extract a data, say from TableA and put the data in say TableB.

I designed a Simple Query say Q1 to extract data from TableB.

I assigned this query Q1 to a report.

Question: When I open the report, the expected Order is

  First      : Execute the procedure so as to populate TableB  from TableA after suitable validations.
  Second : execute the query to retrieve the data from TableB
  Third     : Display the report.

The report should be completely in line with the latest updates in the base table TableA.

Any help appreciated to run this order of execution.

Answer 1

Hi,
in the report Open Event you write somethhing like:


Private Sub Report_Open(Cancel As Integer)
    call PrcA 'passing parameters if needed
    Report.RecordSource = "bolle"
End Sub

---

Cinzia

---

Sito RIO
Il mio Blog