How To open a report bound to Colum3

B

BrianPaul

Here is my following CODE

Dim stDocName As String
Me.Visible = False

stDocName = "RIndexForStudy PLAN"

DoCmd.OpenReport stDocName, acPreview, , "[IndexPageID] = " & [List113]

However This List box is part of a paired list box, (for those who may just
think why doesn't he changed the bound colum) How do I modify the following:

DoCmd.OpenReport stDocName, acPreview, , "[IndexPageID] = " & [List113]
To look at List113 Colum 3 instead of 1 which is bound to the 2nd list box.
Thanks.
 
B

BrianPaul

I Got it on my own. Here is the code that I used If someone else has the
same issue:


DoCmd.OpenReport "RIndexForStudy PLAN", acViewPreview, , _
"(IndexPageID = " & Me![List113].Column(3) & ")"
 

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

Top