thanks for both of you,
i solved my issue with parameter query. its great. presently i am asking a new question. like i have three txt box txt01, txt02, txt03 with text datatype. or a cmd button name as cmd1. i have a form name as form1. and report name as "report2007".
all three text box...