in the aterupdate event procedure add this too
form1!subform1!recordsource="select * from table1 where coun=forms![form1]![subform1]![countrycombo] orderby fields;
i think ur question is how to get the details in the subform according to the country field u selected.
assuming ur
table name is table1
form name form1
subform name subfom1
country field name coun(in the table)
country combo field in form1 named as countrycombo
ur answer can be
in the after...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.