Re: New Quick Tutorial - Exclude Data using a table
Hello Boblarson,I am new to access. I am creating a student database. I have crated a single table for this database and a form. I need help with two combo boxes. I have created these two combo boxes named (Documents Submitted and Documents pending). Thease two boxes I created using "Lookup coloumn". I selected "I will type in the values that I want" for both the boxes. After I filled the values in both as (CV, Ielts, Passport Copy, Certificates, photo id). After this I gave the name and selected "Allow multiple values". Now in my form it shows both the combo boxes and in both the boxes it shows CV, Ielts etc. I can select multiple Items in both the boxes. I hope I am clear up to here.
Now at this point these two boxes (Document Submitted and Documents pending) are showing items (documents names) separately. What I want is to combine the values of both. I want to do is, if I select "CV, IELTS, passport copy" in document submitted box, rest of the pending names (Photo ID, Certificates) should automatically be filled in Document pending box. What ever I didnt select in Document submitted box should appear in Document pending box.
Can you help me in accomplish this. Please guide me through the process how I can do that. I shall be very thankful to you.
For better understanding i am attaching my file with it. Please check it and let me know.