Combo Box

[Jkittle]

I have a form that I pull a part number from a query and store it in a table. I would like to be able to have the part description pull in when i pick the part number. How can I do this?

 

[KenHigg]

Assuming you have a description field you want to store this in I would think you could put a simple dlookup() in the after update of the combo box...


ken

 

[boblarson]

I have a form that I pull a part number from a query and store it in a table. I would like to be able to have the part description pull in when i pick the part number. How can I do this?

1. You shouldn't be storing the description as you can use a query to join back to the description from the part number. That is NOT normalized data.

2. You can just add the description column to the combo box and DISPLAY it in a text box by having the controlsource of the text box be:

=[YourComboBoxNameHere].[Columns](1)

 

[Jkittle]

Thanks Bob! I think I understand now.

 

[KenHigg]

Thanks Bob! I think I understand now.

Just a footnote: I think there are times when it is best for the business process to de-normalize.

Example:

Say you have a part number and it's desription is something like:
"Blue and green with round holes"

And then down the road your description is modifed to something like:
"Blue and green with square holes"

Personally, I would want to know how the desription read at the time the record was created so I would store it


ken