johan, are you putting the parameter in the Query's parameters or in the Criteria Row of the Query?
Why are you using a Recordset for the Query rather than displaying the query or a form based on it?