List Box Selecting

[aingram]

Hi All,

I have a database that has route lists for drivers,
I have a combo box that lets the user select a route and a timescale
and with that data it populates the list box,,,

The list box displays
Route Period Month


Now then,
I need the database to be able to double click on the list box and for it to preview a reoprt,
but i can work out how to set querry criteria from that command

Private Sub LstBox_DblClick(Cancel As Integer)
On Error GoTo Err_LstBox_DblClick

    Dim stDocName As String

    stDocName = "Rpt_Route_MAIN"
    DoCmd.OpenReport stDocName, acPreview

Exit_LstBox_DblClick:
    Exit Sub

Err_LstBox_DblClick:
    MsgBox Err.Description
    Resume Exit_LstBox_DblClick
    
End Sub

I've got a query set up that supports the report the two fields that need to be trasmited to the criteria of the query are :
1. Route
2. Timescale

 

[GumbyD]

I see what you are trying to do, but I would recommend a different approach. I am hoping that your report runs off of a query and not a table - if not you will need to make a query with the table as your data source. Then on the form you are using, where you want to display the report from, change your list boxes to combo boxes - and instead of a double click to display the report add a button to the form - it is more user friendly. Then in your query data source for the report you can use a form field call to get the criteria for your report. The criteria will look like the following:
Forms![NameofYourForm]![NameOfYourField]

So for example the field EmpID from the EmpAbsencePlan form would look as follows:

Forms![EmpAbsencePlan]![EmpID]

or if you want to keep your existing structure you can put a form call in the query behind the report that does a form call for your selected value in the list box. It looks just like the one above. This will work as long as you are not allowing a multi-select from the list box - which makes things much more complex.