Opening a Report reliably-Not my SQL statement?

[Bazzlad]

It's in VBA (Access)
I have a report which grabs data off an open form *Through a query*
[Query grabs data off open form-report shows Querys data]

The problem is it doesn't always open, I get messages like:

access can't find the field FORMS reffered to in your expression
or
the open report action was cancelled.

The problem is, it seems to be totally random, it won't work, and then I'll reopen and it will/won't. There doesn't seem to be any way to 100% guarentee opening it,,,
and it needs to be.
The code I'm using:

'Checks if needed field is filled in
    If not Datebox.Value >= "" Then
    MsgBox "Please enter a Date"
    Datebox.SetFocus
    Else
    'Checks if the form sale is the only open form
    For Each frm In Forms
    If frm.Name <> "frmsale" Then
    DoCmd.Close acForm, frm.Name
    End If
    Next frm
    'Hides the listbox, goes forward a record then 
    'backwards a record-to make sure the data is 
    'saved then re shows the listbox
    List106.Visible = False
    DoCmd.GoToRecord , , acNext
    DoCmd.GoToRecord , , acPrevious
    List106.Visible = True
    'Opens report
    DoCmd.OpenReport "qryreport", acViewPreview

PLEEEEEEEEEEASE Help, It's been driving me mad for a week or longer now!