I have a form, which works fine w/out the pain, but I need it to work
in the pain.

The form uses a listbox to select a persons name, which opens a
report that queries on date and [forms]![frmSelectAnalyst]!
[mylistbox].

Other forms/reports open/run correctly


Has anyone else had a problem w/forms/reports not loading?

On Sep 21, 5:01*pm, The T <teresaei... (AT) gmail (DOT) com> wrote:
No. Look at ItemData, ListIndex, Column, ItemsSelected, and other
associated methods and properties of ListBoxes. You might want to
parse out the values and stuff in an invisible field the query can get
access to.

If this is not a multi select listbox, the default value of the
listbox will be the bound column of the selected item. In the On_Click
event, set up some code to test what value is being passed and compare
this to what is needed.

If it is a multi select, you can do the same with the ItemsSelected as
Patrick suggested.

If you are still having difficulty, please post your code that is
supposed to collect the value from the listbox and the code for the
sub/function the value is passed to.

Steve