Pull Data from another table

[bbranco]

I have a table that contains the following:



Code BrandName Lead Free Nickel Free
001 AAAA Yes Yes
002 AAAA Yes No


On a form the user selects the code field and in this table the field is called BRAND. On the same form, I need to display the value in the Nickel Free field so if selects 001, the field on the form needs to be "Yes", if the user selects "002", the value needs to be "No"

Can anyone help with this problem?

[BCJourney]

Do a search in the forum on returning values based on a combo box. You'll find what you need.