scanning data into a prompted criteria box

[chuckgoss]

Hi all,

I have come so far, but this one still stumps me. I am scanning part number barcodes (3 of 9 non-enhanced) into Access 97. When I scan directly into a combo box or any other control on my form, the part number appears perfectly every time. When I scan into a prompt brought about by [message enclosed in brackets] in the criteria section of my query, Access 97 does not allow multiple identical characters to appear next to each other. For example: Part number 3333-3333 appears like 3-3; Part number 200555 appears like 205; Part number AAAA-AAAA appears like A-A.

Is there something I can turn off or check somewhere that would correct this behavior?

thanks in advance,

chuck

 

[Jack Cowley]

My solution would be to scan the number into and unbound text box on a form and then let the query get the criteria from there. Your criteria would look something like this: [Forms]![FormName]![ControlWithCode]

 

[chuckgoss]

Jack...Thanks a lot. I'll give it a try. Sounds like a workable solution.

chuck