List Box help !!!!!

[Hiten]

I have a list box, which displays a list of contracts confirmed, i want to be able to double click on a contract number and a print preview for that contract appears, or the user can hold the shift button (or something like that) and select multiple contracts to print preview. any advise out there. thanks Hiten

 

[jwindon]

I can help a little, but I hope someone will show us the WHERE part of the argument in this Code.

Enter this code on the OnDoubleClick event of the list box.

DoCmd.OpenReport "rptReportName", acViewPreview, , Me.ContractID

The Me.ContractID part does not work...any help.

I won't even begin to address the multiple select listbox thing. Above my head.