Form On exit event

[Guest]

I have posted this thread last week.
I apologize for posting it again but I could not solve my question.

May be someone else can give me an idea.

I need when closing a form to open a report on a specific record.
So, I have this code:

Private Sub Form_close()
DoCmd.OpenReport "Invoice", acViewPreview, , "[DocId] = """ & Me.[DocID]
& """", acNormal

End Sub

The problem is that it opens the report always on the first record, no
matter which DocId I have.

If I run the code without closing the form it works fine.
I guess that the Form_close() event runs the code after closing the form and
so Me.DocId is Null.

Is there any way for running the code before closing the form?

 

[Rick Brandt]

I have posted this thread last week.
I apologize for posting it again but I could not solve my question.

May be someone else can give me an idea.

I need when closing a form to open a report on a specific record.
So, I have this code:

Private Sub Form_close()
DoCmd.OpenReport "Invoice", acViewPreview, , "[DocId] = """ &
Me.[DocID] & """", acNormal

End Sub

The problem is that it opens the report always on the first record, no
matter which DocId I have.

If I run the code without closing the form it works fine.
I guess that the Form_close() event runs the code after closing the
form and so Me.DocId is Null.

Is there any way for running the code before closing the form?

Try the Unload event instead. The control might no longer contain a value
in the Close event.

 

[Nick 'The database Guy']

Hi Raul,

Try putting in a message box in the sub, msgbox [DocId] for instance
that way you try and insolate the bug.

Also why have you got three sets of speach marks next to each other?

Try assigning the argument "[DocId] = """ & Me.[DocID] > & """" to a
variable and setting a breakpoint and check what is value is.

Good luck,

Nick

 

[Guest]

Thank you both for your reply.
I have used the message box for debug and I found that:
• When the code is run on exit event control´s value is trhe first record.
• When the code is run elsewhere but on exit event control´s value OK.
So, I have used the unload event … and it worked

"Rick Brandt" escreveu:

I have posted this thread last week.
I apologize for posting it again but I could not solve my question.

May be someone else can give me an idea.

I need when closing a form to open a report on a specific record.
So, I have this code:

Private Sub Form_close()
DoCmd.OpenReport "Invoice", acViewPreview, , "[DocId] = """ &
Me.[DocID] & """", acNormal

End Sub

The problem is that it opens the report always on the first record, no
matter which DocId I have.

If I run the code without closing the form it works fine.
I guess that the Form_close() event runs the code after closing the
form and so Me.DocId is Null.

Is there any way for running the code before closing the form?

Try the Unload event instead. The control might no longer contain a value
in the Close event.