I am new to access, I need to accomplish a task ASAP. Kindly help me guys
I have 4 colums
ID ________ Name______ Ref ________code
000033______AFAAF______ 19011961 ______ 9
010000 ______ MAURICE______ 30061939______ 6
010015 ______VARTOO ______ 30061943______ 7
010044 ______NAJAH______ 08111955______ 2
010093 ______ NASER______ 02121936______ 3
010138______ GHULAM ______ 30061945 ______3
010369 ______ SUMAYA ______ 30061940______ 5
010489 ______KHADIJ______ 24081934 ______2
010044 ______NAJAH______ 08111955 ______ 5
010138 ______ GHULAM ______ 30061945______ 1
010369 ______ SUMAYA ______30061940______ 6
I want to build a form, where i can enter the ID and and it search and retrieves all the corresponding Code(column D) values in the same form, respectively for all the instance of the ID (there may be multiple instance of the ID)
Thanx in advance