Append data using datasheet form

[gstylianou]

Dear friends hello,

Maybe the title of the subject is not quite understandable so I explain

I have one ListBox through which I select some data and it is Multi Select Format so i can select more than one record. These data (the selected data) collected and displayed on a Datasheet form and here it is the problem. Please note that, the form has a Control Source one query wich collect the selected data from List Box.
I want the displayed data to append into a table all together and not one-by-one and this is the problem because i cannot append the displayed data from Datasheet form.

I'm trying to find a way in order to append these data using a command button in this from this form but the problem is the datasheet data which cannot append all together but only the first record.

Is that what i need feasible? If so, it would help me even a small example so that I can understand the code.

 

[Ranman256]

Multi-select boxs are complicated. The BETTER way is to either:
show a continous form that has a field PICK (boolean) for the user to pick the record by checking the box, then run a query to collect all TRUE items.
or
make a single select listbox where you can dbl-click an item. this runs an append query to the table you need. Either way (your original idea, or this) the user must select 1 record at a time.

 

[gstylianou]

Hi Ranman and thanks,

But, the Multi-Select List box working fine, what only i need is to append the data through the datasheet form. That's the main problem. Is there a way?

Thanks a lot