thx paul, i checked your link but i couldnt insert where condition to open the report
i think i need to insert code at below, but i don't know how :confused:
DoCmd.OpenReport "ReportXX", acViewNormal, "", " branch_code =" & rst! branch_code
my whole code is below, could you pls help me...