I have two questions from the same form.  

I have a form that contains a Combo box that is populated with a coded(AddItem) list.
It also has a list box that is populated with a dynaset from an Oracle select statement.

1.  Everytime I select a different item from the combo list, I would like to have
    the list box display the results of a different select statement.

Example:  combo box = complete    list box = users with access to complete data
          combo box = general     list box = users with access to only general data

Any ideas?

2.   The List box displays Username, Create Date for users.  I would like to select
     an item from the list box and use the username for other things.

how can I get the username?

Thanks in advance.

: 1.  Everytime I select a different item from the combo list, I would like to have
:     the list box display the results of a different select statement.

: Example:  combo box = complete    list box = users with access to complete data
:           combo box = general     list box = users with access to only general data

On the click event of the combo box you build a SQL statement.

  Select complete from table

This SQL statement is used to create a snapshot or a dynaset of the table
in the db.  Using a loop you can then add the items from the statement
into the listbox, and the refresh the listbox.  You'll also need to clear
out the lisbox before you re-populate it otherwise the conetnts will
begin to grow.

: 2.   The List box displays Username, Create Date for users.  I would like to select
:      an item from the list box and use the username for other things.

: how can I get the username?

Is the Username in the listbox or the create date?  If it is the user
name you can use the currently selected item in another SQL statement or
whatever you want to do.

--
---------------------------------------------------------------------


|-------------------------------------------------------------------|
| The opinions expressed are mine, all mine........                 |
|-------------------------------------------------------------------|
| Time is nature's way of keeping everything from happening at once |
---------------------------------------------------------------------