- Joined
- Oct 23, 2012
- Messages
- 3
- Reaction score
- 0
Hi,
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
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