Al,

I am trying to do something simiar. How do you create the 3 column combo
box? I think it will work for me!

"Al Campagna" wrote:

1st,
Your post has me confoosed...
Why would entering a bar code prevent your using my suggestion? It would also seem to
me that the barcode should contain a unique value that would define the Price and Desc...
why a manual ItemNo entry at all?
What field in this scenario will be responsible for determining the Desc and Price?
Please give a bit more detail. This is definitely do-able, we just have to establish
what the setup is, and what info does what.

And, a minor point... please don't delete previous responses from your replies. That
way, everyone can see the "flow" of the problem in the last post.

--
hth
Al Campagna
Candia Computer Consulting
Microsoft MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."



"1st Texas Sales" 1st Texas wrote in message
...
I'm afraid that will not help me on this. Basically I am trying to setup as
a Point of Sale system. I will enter in the item number, scan the barcode and
need it to pull up the product and its set price.



"1st Texas Sales" wrote:

I have been using a invoice database to invoice my customers for a while and
now want to update it so that the product name automatically enters based on
the product number I put in another field. Example below.

Item Number field, I type in 101 and then the field of description would
automatically enter "Candy Bar" and would automatically enter the price in
the next field.

Anybody that knows hoe I would do this I would greatly appreciate the info.
Thanks