How Do I List Data From Access in Parameter Prompt

[RobDog888]

Use the parameters collection of your report object in VB.

[zombiee79]

Use the parameters collection of your report object in VB.

Thanks a lot..but can u give me an example.What i have done so far:

Private Sub cmdPrint_Click()
Dim criteria
    Screen.MousePointer = 11
 
   With CrystalReport1
        .ReportFileName = App.Path & "\RPT\RPTLocation.rpt"        
        .DiscardSavedData
        .WindowShowCloseBtn = True
        .WindowShowRefreshBtn = True
        .WindowState = crptMaximized
        .WindowShowSearchBtn = True
        .WindowTitle = "Location "                          
         .Action = 1
    End With
    Screen.MousePointer = 0     
End Sub

I just create a parameter on CR only.Please let me know how to do it in VB.So it will be listed out all of the location in Paramter Prompt.Thanks