Cut and Paste a list into a bound table

[gblack]

I am trying to make a little tool using access.

I want to take a list (excel, flat file, access table, whatever...) past it into a table then click a button and have access spit out an IN() function. That way, whenever I have a list I want to throw into the criteria section of a query (SQL, GUI... whatever)... I can copy my list into the table press a button and bam!

I have completed that part. Then I thought it'd be keen if (open opening this file) if I could get the table I will paste to, to open up. The problem is I can't seem to get it to open in front of the form I made.

So I made a form and bound the table to it... now I can get that form to pop-up in front of the main form which makes my function.

The issue is, I can't paste a list of data into the table, because the form only allows you to paste data into one "cell".

So I am asking for a solution that could be either or... How can I get the table to pop up infront of the form when I open my database file...OR... how can I get the Table-Form to allow my to cut and paste into the entire table?

Thanks,
-G