Access Text Select

[Kaine]

Helo, im new to this. i have a report which lists out all people in a table. what i one is to make the report in access to display certain values i want from vb. any ideas?

Private Sub cmdShowRpt_Click()
On Error Resume Next
Set AccessApp = New Access.Application
 
With AccessApp
    .Visible = True
    .OpenCurrentDatabase "c:\aff.mdb"
    .RunCommand acCmdWindowHide
    .RunCommand acCmdAppMaximize
    .DoCmd.OpenReport "Titles", acViewPreview
End With
End Sub