combo box to update subforms?

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 only the data I need 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
 
S

Stu_Mc

Thanks Al

I have been away from Access for a couple of years and its taking me time to
get my head back around it!

The requerying the subforms works great - AFTER I remembered I hadn't put
the query condition on the subforms that it should equal the listbox.value
before requerying!

Thanks again!

Stu
 
Top