Using combo box to look up records?????

[brandonze]

OK, So I have a combo box. I am using it in my small scale sample DB so as not to screw up my huge DB.

Combo box is named Field 1. It works to lookup the other fields in the DB. It woerks well at this.

Enter wrench in the plan. I bound the combo box to a textbox that I am using a Mid function to pull the data form a barcode that I need.

It pulls the data just fine. Matches what is in the combo box letter for letter. But the combo box won't look up the record anymore.

Any ideas?

[RuralGuy]

If you want the cbo to look up records then you do not want it to be bound to anything.

[brandonze]

Well, that answers one question and opens up another. I could scan my barcode directly into the Combo box, the barcode is 20 characters and I only want six. any sugestions?

The six would be what is in the combo box list. so the operation would have to be before the emmbeded macro operation