Listbox help!

[tkaplan]

I have a form with a listbox on it. the list box contains site numbers. (lstSite)

i would like the user to select which site/s they want information for.

i have another query that includes site,date,and other data
i put in the criteria for site as being forms!main!lstSite.value but it is not showing any records, even if i did select the site. i also tried forms!main!lstSite. this did not work either.

I have a feeling i am refering to the object incorrectly.

any help would be greatly appreciated

tkaplan

 

[seth_belgium]

The criterium should be : [Forms]![main]![lstSite]

If that still doesn't work, check that the value returned by the listbox is the correct value. You can do this simply by adding a button to your form with the following code behind it:

Private Sub Buttonname_Click()
MsgBox Me.lstSite.Value
End Sub

Check if the value that's shown in the dialogbox is the desired one.

Cheers,

Seth