Access Access use textbox multiple values as query criteria

Oct 23, 2012
Reaction score

I cannot find a thread anywhere for what i'm after, so any help would be much appreciated!

I want to use a multi line textbox on my form, as criteria in a query.

Each value entered in the textbox would be a 6 or 7 ID code.
The reason I've gone for this is that a lot of the users have various ID codes in Excel columns, so they can easily paste it in. I cannot do it as a list selection as there are around 30000 codes.

Can anyone give me a code that can do this? Or something I could manipulate? I'm only just getting into Access.

Form: SearchForm
TextBox: CodeEntry
Query: MasterCodeSearch
Query Field: MasterCode

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question