Help with Listbox to run report.

[dbouton]

I have a form w/ a listbox. The listbox contains info from the same table a
generic report is based on. I want to use double click on a record in the
list box to display on the record double clicked in the report. What is
happening is the report is running but with every record in the table, not
just the one displayed. Can someone help me with some advice?

 

[Steve Schapel]

Dboulton,

I would guess that you are using an OpenReport action in a macro hich is
assigned on the Dbl Click event of the listbox. Am I right? First of
all, I would recommend you use the After Update event of the listbox,
not Dbl Click. And then, the Where Condition argument of the OpenReport
action can be someting like this...
[YourID]=[Forms]![YourForm]![YourListboxName]

Hope that helps. If you need more specific advice, please post back
with more details about what you are doing.

 

[dbouton]

DUDE!!! You are a Fricking Genious! Soooo Many thanks to you.


--
If you were meant to understand it, it wouldn''''t be called "Code"!

Dboulton,

I would guess that you are using an OpenReport action in a macro hich is
assigned on the Dbl Click event of the listbox. Am I right? First of
all, I would recommend you use the After Update event of the listbox,
not Dbl Click. And then, the Where Condition argument of the OpenReport
action can be someting like this...
[YourID]=[Forms]![YourForm]![YourListboxName]

Hope that helps. If you need more specific advice, please post back
with more details about what you are doing.

--
Steve Schapel, Microsoft Access MVP

I have a form w/ a listbox. The listbox contains info from the same table a
generic report is based on. I want to use double click on a record in the
list box to display on the record double clicked in the report. What is
happening is the report is running but with every record in the table, not
just the one displayed. Can someone help me with some advice?