G
Guest
I can't get a command button reference to a button. Every time I select the
[event procedure] on the button it creates a new sub procedure. I want to
reference this button to a procedure I already created. It keeps creating
new sub-procedures when I open the [event procedure] on the command button.
I gave it the name of the right procedure but when I click the button it
says member already exists. The reference is to the new procedure that
creates when you go to [event procedure]. Every time I open the properties
it is on an empty procedure below the one I want it to be on.
The other problem is when it creates a new subprocedure it says it is a
toggle button with a focus(). On got focus.
The sub procedure someone gave me doesn't have that it has a click event.
I can't figure out how to have a regular button. They all seem to be toggle
buttons. This is just for a report.
In case you want the subprocedure here it is:
Private Sub cmdOpenFilteredReport_Click()
'On Error GoTo Err_cmdOpenFilteredReport_Click
Dim stDocName As String
Dim strFilter As String
strFilter = "[ResolutionID] IN ('Resolved Some Issues', 'No Resolution',
'Full Resolution')"
stDocName = "rptMediatorEvaluation"
DoCmd.OpenReport stDocName, acPreview, , strFilter
End Sub
The original need is to filter a report on 3 categories of the REsolutionID.
tia, I hope you can clear this up.
[event procedure] on the button it creates a new sub procedure. I want to
reference this button to a procedure I already created. It keeps creating
new sub-procedures when I open the [event procedure] on the command button.
I gave it the name of the right procedure but when I click the button it
says member already exists. The reference is to the new procedure that
creates when you go to [event procedure]. Every time I open the properties
it is on an empty procedure below the one I want it to be on.
The other problem is when it creates a new subprocedure it says it is a
toggle button with a focus(). On got focus.
The sub procedure someone gave me doesn't have that it has a click event.
I can't figure out how to have a regular button. They all seem to be toggle
buttons. This is just for a report.
In case you want the subprocedure here it is:
Private Sub cmdOpenFilteredReport_Click()
'On Error GoTo Err_cmdOpenFilteredReport_Click
Dim stDocName As String
Dim strFilter As String
strFilter = "[ResolutionID] IN ('Resolved Some Issues', 'No Resolution',
'Full Resolution')"
stDocName = "rptMediatorEvaluation"
DoCmd.OpenReport stDocName, acPreview, , strFilter
End Sub
The original need is to filter a report on 3 categories of the REsolutionID.
tia, I hope you can clear this up.