S
Stu_Mc
Hi All
I have 2 tables that contain similar data but only 1 field that can be
linked by field Road_Num. Each Road_Num record has several entries in each
table and I need to display these on the same form for direct comparison.
I have set up queries to bring out on ly ther data I am interested in for
each table and then created 1 form with sub-formsfrom these queries. I have
also put a combo box on the form that allows the user to select the Road_Num
field to compare.
I have done this years ago but I cannot get the combo box to update the 2
subforms. I seem to remember using the Afterupdate() event?
Any help would be gratefully received!
Cheers
I have 2 tables that contain similar data but only 1 field that can be
linked by field Road_Num. Each Road_Num record has several entries in each
table and I need to display these on the same form for direct comparison.
I have set up queries to bring out on ly ther data I am interested in for
each table and then created 1 form with sub-formsfrom these queries. I have
also put a combo box on the form that allows the user to select the Road_Num
field to compare.
I have done this years ago but I cannot get the combo box to update the 2
subforms. I seem to remember using the Afterupdate() event?
Any help would be gratefully received!
Cheers