On Sun, 5 Jun 2005 12:10:44 +1200, windandwaves wrote:
Hi Gurus
I have a bunch of reports where I have added the following function to the
onclose event:
=FROC()
where FROC() opens a form.
However, i found that if i have a report with more than one page, froc is
executed when I go from page 1 to page 2. Is there a way to stop this from
happening?
TIA
- Nicolaas
If the form is opening as you go from page to page, you have something
else opening the form, not this code.
1) Writing
=FROC()
(as you have posted it) in the close event will cause a compile error.
2) If all you are doing with the function is opening a form, you don't
need a function. A function is used to return a value. No value is
being returned.
You can open it directly in the close event using:
DoCmd.OpenForm "FormName"
3) If for some reason you need to do it outside of the close event, a
sub procedure would be more suitable than a function:
Sub FROC()
DoCmd.OpenForm "FormName"
End Sub
In the Close event you would then call the procedure using:
froc
No = sign and no parenthesis.
The above will only fire when the report is closed.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.