Re: Field to automatically put value depending on code entered in anot

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

1st,
Try using a 3 column combobox (ex. cboItemNo) to make ItemNo selection. Limit to List
= Yes
cboItemNo Columns...
ItemNo Desc Price

As a general rule, it is not recommended that you "save" the Desc and Price values, but
just "display" them to the user. Since your capturing the ItemNo, you can always
re-derive the Desc and Price "on the fly" in any subsequent query, report, or form... due
to the relationship ItemNo has to the Desc and Price fields.
Two calculated "unbound" controls will do the trick. (combo columns are numbered 0, 1,
2, 3, etc...)
txtDesc...
= cboItemNo.Column(1)

txtPrice...
= cboItemNo.Column(2)
--
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 Sales@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F10CA1C1-12DD-45DC-B484-0B8EF8613002@xxxxxxxxxxxxxxxx
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


.

Relevant Pages