Selecting multiple values from datasheet

[vbcraft]

Hi,
Is there a way to select multiple rows in a subDatasheet and have those
selected rows (or values in the selected rows) placed in a list box on it's
parent or main form.

 

[vbcraft]

thanks for the quick response.
I am a little confused. I am working with a datasheet view not a listbox.
Sorry maybe that was not clear or I am missing something.
I have a datasheet view and in a datasheet you cannot have buttons. So i
added coded behind a specific field which adds its Primary Key to the main
form so that i may do something with it.
The question i have is ... is there a way (once the user selects multiple
rows in the datasheet form) to have all the selected rows accessible in code.
Just like a list box has the selected=true function...does a datasheet have a
selected.record=true or something.
Thanks again for your response!

--
Thank you,
vbcraft

The rowsource for a listbox can be a query. Create a query that returns the
records in the selected rows and make the query the rowsource of your
listbox.

Steve
(e-mail address removed)

 

[vbcraft]

I do not know how to reference selected rows in a datasheet.
If you could tell me how to do that i'd be able to do something with those
records...(might be putting the values in a list box or a message to user or
store values in a table, ect...)

 

[Gina Whipp]

vbcraft,

You cannot do this from a Datasheet. Datasheet view will allow you to
select one row at a time. WHat about using two list boxes?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Dirk Goldgar]

vbcraft,

You cannot do this from a Datasheet. Datasheet view will allow you to
select one row at a time.

Not exactly. A datasheet will let you select multiple rows, so long as they
are contiguous.

 

[Gina Whipp]

Dirk,

This is correct, however it not the impression I got from his original
posting. Though I should make a note of that when I say "You can't do
that...".

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm