'Pleae help, I'm using Access 2000 and have a table "Matl Test" with 4 fields, "TestMethod ID", "TestMethod", "Item", & "Category". On the matl form I have a combo box linked to this table to the "Item" field. When the users selects the appropriate item I want the category field be posted into the text box below, basically linking the item selected in the combo box to the appropriate category. I have already tried coding this code in the category text box. Private Sub Item_AfterUpdate() Me![Category] = Me![Item].Column(2) End Sub
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.