I am using the following code to generate the report of specified bill_id

    Report1.DiscardSavedData = True
    Report1.SelectionFormula = "{Orders.Bill_Id}=" + CStr(dcBill.Recordset!
[Bill_Id])
    Report1.Action = 0

Sometimes it generates the report and sometimes does not.
I have trie dit in designing of report in Report Designer by implementing 
the SelectionFormula, it worked there. Why it is happening with VB code

Help required.
Saif