I would like to do the following:
1. Pick item in combo box from a table that is used as a lookup. This table also contains the description of the code. (Ex. Column 1 = shoe type column 2 = colour) 2. Once picked, it would write the shoe type value into my data table 3. Also once picked, it needs to update the text box on the same form with the colour of the shoe and also update the data table with the same description. Please help. I am using access 2003. I hope this makes sense. Thanks
|
|