Data Report Code for Run time parameter

[DK47]

Hey All,
Is there a way to code parameter searches to fill a data report by the user?

We have an access database using SQL and we need to draw Dates and Values based on which user is logged in.
The code I use for this which loads a datagrid is:

frmHoldings.adoHistory.RecordSource = "SELECT * FROM History WHERE Investor_Number = " & frmStartPage.txtInvestorNumber & " Order By Date DESC"
frmHoldings.adoHistory.Refresh

How would I go about coding the command object of the data environment to return only dates and values based on frmStartPage.txtInvestorNumber?

Thanks
Dwight