using a list of values as criteria in a query

[Bendiesel]

Hi all -

I would like to give users the ability to upload a list of part #s to insert as criteria into a query. Ideally, the user would be cut and paste the values from an excel file into a text box within an access form. Since the number of items could go well beyond 100+, individual text boxes for each part # wont work.

Anyone know how I could do this?

Thanks in advance,

 

[PHV]

I'd populate a temporary table of part# and I'd join it to the query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Bendiesel]

Im sure I'm showing some ignorance with this question. Since there will be multiple users with differing criteria (at the same time), wont that create a problem? Or, does a temp table that is joined only affect the current user?

 

[PHV]

does a temp table that is joined only affect the current user
Provided the temp table is in the local FrontEnd db

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886