Search results

Hello, I am new to access and can design simple forms and tables. I am designing a form for patient's record. I have one table to record the data from which I have created the form with the same field names. I have two situations. 1. Combo 1 (CboExamination) --Options = Normal, Abnormal and not...

Thanks Bob. I see that you have built querry in combo 2 and put VBA code as afterevent porcedure in combo 1. How do you set rowsource property?Can you let me know the steps how to do it? I tried to add case "D" in combo 1, I added column 4 in table 1, but I could not get the fourth set of lists...

Hello Bob, Can you help me please with one more code condition is like this --- have 2 combo boxes Combo1, Combo2 Combo 1 has options A, B, C If I select option A in combo 1, Combo 2 should list items in column 1 of Table 1 If I select option B in combo 1, Combo 2 should list items in column 2...

Thanks again Bob. I did for 3 also, I had to keep VBA codes for each cases separately. It worked. 3 is reverse of 1. In 1, you have written row source. For 3, I could not put row source and I kept VBA codes individually for each case.

Thanks Bob! It worked

Hello I am new to access. I am using Access 2010 and designing simple database. I want to autofill a field depending upon a value selected in previous combo. I have three situations 1. combo after combo I have one combo Hypertension -- yes/No/unknown If hypertension is "yes", I would like to...