filtering a report

[seemh]

hi
i'm trying to create a report in Microsoft access and i need this report to be filtered using data entered via text boxes. so i used an SQL statement and assiged it to the report's recored source.
but when i tried to execut i had the following run time error: you can't set the record source property after printing has started"

can any1 tell me what did i do wrong and if there is another way i can filter the report

thank u in advance

 

[PHV]

In which event procedure you modify the report's recored source ?
Where are located the TextBoxes ?
You may consider the 4th argument of the DoCmd.OpenReport method instead of reassigning the Recordsource.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZmrAbdulla]

Martin Green has an excellent example here,

http://www.fontstuff.com/access/acctut19.htm

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.