I have an odd problem that I can't figure out a decent way to do it. I have a simple table:
Table1
Item Price
1 $5
2 $10
3 $15
4 $20
I'd like to have a form where the users could paste a list of the items they want to query off of, then click a button and the item criteria is then based on that custom list. I've been playing around with using the replace function but that doesn't seem to help any. I'm trying to avoid appending and deleting constantly from temporary tables as there will be multiple in the same form as one time.
Any ideas?
Table1
Item Price
1 $5
2 $10
3 $15
4 $20
I'd like to have a form where the users could paste a list of the items they want to query off of, then click a button and the item criteria is then based on that custom list. I've been playing around with using the replace function but that doesn't seem to help any. I'm trying to avoid appending and deleting constantly from temporary tables as there will be multiple in the same form as one time.
Any ideas?