I am beginner

Joined
Feb 28, 2006
Messages
1
Reaction score
0
Hi,

i would like when I close my report:

I have a popup with yes or no button:

if yes I would like to call private sub open_report()

else
close access application.

For the moment I do this:

Private Sub Report_Close()

Dim LResponse As Integer
LResponse = MsgBox("Voulez-vous entrez une autre date?", vbYesNo, "Continue")
If LResponse = vbYes Then
**HOW TO CALL OPEN_report() *****
Else
Dim appAccess As Access.Application
Access.Application.CloseCurrentDatabase
appAccess.Quit
End If
End Sub


thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code to change form recordsource 1
Key Press 8
Yes No Message Box 7
SendObject Email 2
SendObject code 6
SendObject and combo boxes 1
new email form in front of MsgBox 1
add record in combo 6

Top