Which control, and how to work with the multiple values se..

Hi all,

I'm a newbie to VB, trying to transfer over my VBA/Access skills. I'm
trying to set up two listboxes/datagrids (not sure which control to
use), each with two columns. The controls will be used to select one
or several values in each case. The first control ("choose one or
many companies") will filter the data in the second control (so that
you only see leases for those companies chosen). Once the user has
chosen one or several leases from the second control, those values
will be used to build a SQL statement for a recordset that I'll run a
Crystal Report on. So, my questions are these:

1. Which control should I use? I originally thought of a listbox
with two columns, but apparently they don't work in VB the same way
they do in VBA/Access, and a datagrid or datalist (or DBList?) is the
way to go. Is this right? Which one is best for this job?

2. How do I collect the primary key or bound column of the first
control's selected row so I can filter the second control if there
isn't a property like "SelectedItem"? I don't see a property that
looks likely when I use the Object Browser for a datagrid...

3. I think if I knew how to solve #2, then I would understand how to
collect the one or several values indicated in the second control to
use with my recordset. Does this sound right? If not, how would I do
it?

Thanks so much for your help.

First, the choice of control is a purely pragmatic one, according to user
functionality: what do you actually want the users to see and be able to do?

For the list controls (listbox, combobox), you can put the record IDs in the
ItemData() property. Use the ListIndex property or Selected() array to check
which items have been selected.

For the grid controls, you can put the IDs in the RowData() property. Check
what's selected by looking at the .Row and .RowSel properties.





"Robin" wrote in message

 > Hi all,
 >
 > I'm a newbie to VB, trying to transfer over my VBA/Access skills. I'm
 > trying to set up two listboxes/datagrids (not sure which control to
 > use), each with two columns. The controls will be used to select one
 > or several values in each case. The first control ("choose one or
 > many companies") will filter the data in the second control (so that
 > you only see leases for those companies chosen). Once the user has
 > chosen one or several leases from the second control, those values
 > will be used to build a SQL statement for a recordset that I'll run a
 > Crystal Report on. So, my questions are these:
 >
 > 1. Which control should I use? I originally thought of a listbox
 > with two columns, but apparently they don't work in VB the same way
 > they do in VBA/Access, and a datagrid or datalist (or DBList?) is the
 > way to go. Is this right? Which one is best for this job?
 >
 > 2. How do I collect the primary key or bound column of the first
 > control's selected row so I can filter the second control if there
 > isn't a property like "SelectedItem"? I don't see a property that
 > looks likely when I use the Object Browser for a datagrid...
 >
 > 3. I think if I knew how to solve #2, then I would understand how to
 > collect the one or several values indicated in the second control to
 > use with my recordset. Does this sound right? If not, how would I do
 > it?
 >
 > Thanks so much for your help.