multiple selection in dataform

[ideasworking]

Can anyone get me started with multiple selections in dataforms? I want to be able to work with multiple records selected on a dataform. For example.... choose five records and append them to a table.

 

[San22]

Can u be a bit more precise with ur query

 

[ideasworking]

Well....

I have a subform that is dataview only. I want to be able to highlight multiple records and insert them into another table.

Not really knowing how to make this happen I envision a collection that includes all the record data for the records highlighted. The collection could then be broke down to records (1,2,3... and so on) and fields (1,2,3... and so on).

I know this won't work but... if I could make code work... this is what I would write.

Dim rstSelected as recordset
Set rstSelected = forms!frmMain.Listwindow.form.SelectedItems

Even if I could generate a list of values from one field (the key field) of the highlighted records... that would be fine. I could use that information to do what I want.

Is this making it any clearer?

Thanks for posting a response....

Cheers!