G gfcaim Registered User. Local time Today, 14:58 Joined May 26, 2004 Messages 20 Jun 10, 2005 #1 How do i pass the parameter of a query in VBA? My line is: cldDetail.SourceObject = "Query.qry_CDs", but the query requires a parameter (customer number).
How do i pass the parameter of a query in VBA? My line is: cldDetail.SourceObject = "Query.qry_CDs", but the query requires a parameter (customer number).
ColinEssex Old registered user Local time Today, 14:58 Joined Feb 22, 2002 Messages 9,451 Jun 10, 2005 #2 This article explains about parameters and VBA. Also, do a search, Pat Hartman has posted loads of useful stuff on this. Col
This article explains about parameters and VBA. Also, do a search, Pat Hartman has posted loads of useful stuff on this. Col