How I can get a multiple selection from the sub-form. ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a list box it has approximately 1,500 record. When I scroll down it
is too slow.
I did try to use sub-form (datasheet view) instead of the list box but I do
not know how to get a multiple selection from the sub-form.

Thanks in advance
 
Hi,
you can add a field "Selected", show it as a checkbox on a form and use it
to select records
 
Alex,

I have a list box already but when user try to scroll down it is too slow. I
was thinking to replace the list box with a sub form filed but I do not know
how can I get the multiple selection from sub form.
For example, the sub form it will show as a one-field table and user can
select multiple rows. How can I get the value of these selected rows?

Thanks,
Mike
 
I would add an event to the DOUBLE CLICK event of the subform detail
which uses code to fill a listbox. This provides you with what you're
looking for AND has the added benefit of showing you the values that
you've selected. If you have 1500 records and select the first and then
scroll down to record 100, you may forget that record 1 was selected.
 
Hi Mike,
you can get select records in datasheet using .seltop, .selheight
properties.
but i would suggest checkboxes
 
Back
Top