Help!!!
I'm working in a database that has 2 tables - one is Permit which holds addresses with Permit # as the key and the other table is Srp which holds the data for the the Permit # every year. On my form I'm running Srp as a subForm so I can add a new records (Permit Number is also in Srp table). What I'm trying to do is on my Subform Srp I want to have a combo box with the Years in it that autofills the rest of the fields. I have the combo box working great but the problem is when I select the year I want it to change all my fields on my subform for that year and Permit # across all tabs. I've tried everything I can think of. Any help would be greatly appreciated.
I'm working in a database that has 2 tables - one is Permit which holds addresses with Permit # as the key and the other table is Srp which holds the data for the the Permit # every year. On my form I'm running Srp as a subForm so I can add a new records (Permit Number is also in Srp table). What I'm trying to do is on my Subform Srp I want to have a combo box with the Years in it that autofills the rest of the fields. I have the combo box working great but the problem is when I select the year I want it to change all my fields on my subform for that year and Permit # across all tabs. I've tried everything I can think of. Any help would be greatly appreciated.
