DoCmd.OpenReport MS Access with Parameters?

Question

I am attempting to open a report in preview mode which has a single parameter of [BillingPeriod] type Text.  Here is the code that I have however, it will not work.

lstSQL is a selection box, I know that it is pulling the correct selection.  However, when I run the code I get the following error:
Syntax error (missing operator) in query expression '(2Q2007)'.


    Dim stDocName As String
    Dim BillingPeriod As String
    
    BillingPeriod = Me.lstSQL

    stDocName = "Billing Statement"
    DoCmd.OpenReport stDocName, acPreview, , BillingPeriod

BlueFeather · Accepted Answer

It looks like you are trying to open a report by some kind of action on a form.
(click a command button or select an item from lstSQL)

What is lstSQL  -- ComboBox or ListBox?
("selection box" is not appropriate terminology for either)

I assume you mean ComboBox; therefore the code would be:

DoCmd.OpenReport "Billing Statement", acViewPreview, , "BillingPeriod = " & Me.lstSQL

§

Note: before executing the DoCmd statement, your code should first check to ensure that an item has, in fact, been selected.  (either that or put the statement into the OnClick event for lstSQL)

You won't need "BillingPeriod = Me.lstSQL" or stDocName

? · Answer

Docmd.openreport

Rachel · Answer

I don't know the answer - but I bet that someone on google groups would know.  Whenever I have access questions I search on there and can usually find the answer.  Good luck.

Trending News

DoCmd.OpenReport MS Access with Parameters?

3 Answers