text box dependent on other text box entry

[Shannan Casteel via AccessMonster.com]

I want to have a form with 40 PartNumber text boxes, 40 PartDescription text
boxes, and 40 PartPrice text boxes. The name of each would vary of course,
but I want to be able to enter the part number in the PartNumber in the
PartNumber text box for each replaced part. After the number has been
entered the PartDescription and the PartPrice should show up in the other
respective text boxes. I will be linking to a table that includes 3 columns
labeled PartNumber, PartDescription, and PartPrice. For instance, if I enter
"12345" in the PartNumber text box then the description of the part along
with its price should appear in each of their respective text boxes. If
PartNumber 12345 is a Washer that costs 0.75 then The PartDescription, and
PartPrice should read Washer in PartDescription text box and $0.75 in the
PartPrice text box.

In other words I need some code or method that upon entering a PartNumber in
the PartNumber field finds the record referred to and then returns the value
other columns in the table. There should be no error if a field is left
blank.

This database will be used to enter warranty claims, so that the user will be
able to enter parts and automatically know how much they will be reimbursed
for the part.

Thanks for your help,

Shannan Casteel
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200507/1

[pietlinden]

hmm... 40 partnumber textboxes? Are you sure you don't want something
like a datasheet?

you can create a combobox with any number of columns you want and hide
all but the first. Then set all the textbox control sources to

cboChooseAnItem.Columns(1)

column counts are zero-based. so the first textbox will show the value
from (2-1)=1.
so your textboxes would have ...Columns(1), Columns(2)... etc

HTH