[SOLVED] Forms: wait until textbox string is finished with a return key before a vlookup

[niels007]

Hiho,

We want to use a barcode scanner to help with our inventory management.
When scanning, the scanner actually 'types' in keys followed by the enter key. (i.e. "Big box of bolts")
With a custom form I want to scan a barcode, then perform a lookup to find item information. (i.e. "These are M10 bolts made from steel")

Since there are many inventory items, I want minimal use of keyboard and mouse for the operator.
A custom form will do the job!

I want to let the barcode scanner fill out a textbox, and then use this value in a lookup to find the other information.

This is what I do now:

Please Login or Register  to view this content.

The problem is, it will do the Vlookup after each entered character that is placed in the textbox. It doesn't wait for the enter key to be pressed to 'confirm' the entry.

So it doesn't wait for "Big Box Of Bolts" to be entered, it will see "B" and try to look that up.

How can I make the textbox more patient so it only goes ahead with the lookup after it actually recognizes a text being completed by the enter key?

Cheers!
Niels

[mehmetcik]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[humdingaling]

not quite sure what syntax you are using
but it seems like your using the TEXTBOX change event

maybe use a Keydown (or Keyup) event instead

Please Login or Register  to view this content.

[bakerman2]

Or you could try the AfterUpdate event.

[niels007]

Thanks for the replies people!

I wanted to avoid uploading files and making it too complicated, in case somebody like bakerman2 came along with the perfect 7 word sentence.

Thanks everybody for being here and being so patient towards the less able! :-)

[bakerman2]

Glad to help.