Recent content by rlischer

You know it!

Thanks very much! I have been racking my brains all day and it was just one missing comma!

Thanks. Even if I hard code the invoice number like below, I still get them all and not the one I wanted: appAccess.DoCmd.OpenReport "rptInvoice", 2, "inv_number = 'CT-HIC024'"

ok, Does the Access Query qryInvoice need to have a paramerter in it at all? Like [inv_number] or [parameter] ? Thanks

I am new to VB and I am stuck. I am trying to pass an invoice number to a report that has a parameter query behind it. I get all invoices and not the one I enter. Can somebody see what I am doing wrong? The database in "addata.mdb", the report is "rptInvoice" Thanks! Dim DBPath As String...