OpenReport based on list box result

[Xarkath]

Hello,

I am trying to setup a button that will open a report on click. The catch is that the report name is coming from a query result that is populated into a list box. The way it works the list box will never have more than one result so by default it will always house the name of the report appropriate to a chosen client. I would like to do it this way so that I don't have to clutter up the from with extra buttons all pointing to specific reports.

I found some refrences to this in this forum, including the example listed below, but I have been unsucessful in making work so I assume that I am entering wrong, entering it the wrong place or maybe the code is incomplete. Unforntunately I am a complete novice to Access VBA so I am still learning how it all works together.


List box name is BillingFormat
The first of 5 reports is named Standard Billing

So in the form I enter the client number and BillingFormat is auto populated with Standard Billing

I tied the button to this code: DoCmd.OpenReport Me.BillingFormat, acPreview

The results I was looking for was for the report named Standard Billing would open. The first way I set it up nothing happened not even any errors. The other way threw an error stating it did not recognize DoCmd as a valid function.



Can someone tell what I am doing wrong? Am I even on the right track?

Thanks

[ssanfu]

What is the SQL for the list box?
What is the bound column number?

[Xarkath]

Okay, my Access ignorance is showing. I don't see a way to veiw the SQL for the list box. Did you mean the SQL of the query the list box is pulling from? The data is in the 10th column of the query so if I understand correctly that the columns start at zero then that would be column 9.

[ItsMe]

Maybe you can start by pasting the rowsource of the listbox here.

[Xarkath]

SELECT [GS Secondary Details].[Billing Format] FROM [GS Secondary Details] ORDER BY [Billing Format];

[June7]

The RowSource and the OpenReport both look correct.

Is a form/subform arrangement involved? Bound or unbound forms? If you want to provide db for analysis, follow instructions at bottom of my post.

[Xarkath]

I don't understand why it made a difference but I made what I would think would be a small change and now it is working. I copied then deleted the code, changed the name and caption of the button then pasted the code back in and now it is working perfectly. I am not sure why the name or caption would make any difference but something about it did.


Thanks

[ItsMe]

It happens that way sometimes. If you can imagine numbers that count each line of code in the VBA editor..... You don't want to drag around a sub routine e to a different line number.

The code in the middle of a procedure is one thing. But Access does not like it when you move the first or last line of a routine.

There are other ways to goof things up too