Pivot table - double-click event to open another form

G

Guest

Hi there!

Newby to the MSDN forums and please forgive my ignorance and mistakes!

I am creating a database with which I plan to analyse certain conferencing
usage data and am making use of forms containing subforms displaying pivot
tables.

What I would like to do is to be able to 'double-click' a value/field in
that pivot table, resulting in another form opening and showing the
corresponding 'detail' record. I used to be able to use the docmd.openform
method and 'feeding' it the criteria for the record. I now can't even get the
data from the pivot table to pipe into the openform command. I have tried
using the full name of the subform, but it doesn't seem to work with the
pivot table.

Private Sub c_ConferenceID_DblClick(Cancel As Integer)
Dim stLinkCriteria As String
stLinkCriteria = "[c_ConferenceID]=" & Me![c_ConferenceID]
If IsOpen("Billing Summary") Then
Forms![Billing Summary].Visible = False
Else
End If
DoCmd.OpenForm "Meeting detail", , , stLinkCriteria, acFormEdit
DoCmd.GoToRecord acForm, "Loans", acPrevious
End Sub

I really like the pivot table presentation as it allows me to
collapse/expand data quickly and have a nice clean presentation of the data.

Very greatful if anyone could help me out on this one!

Thanks in advance,

Hans
 

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

Output to Excel Coding Suggestions Please 6
cannot filter continuous form data 2
Open form to a specific item from continuous form 3
open form in pivot table view, from another form 2
Open form in pivot chart view 5
Canceling a double-click event 4
double click event to open form where 3
Access Click in Table to Open Form 0

Top