Run-Time error 5

[nadesico]

Hi,

I am using Access 2000, and have been using a form for the past year with no
problems, then when I tried running the form today, I got a run time error 5
prompt, and I have no clue as to why this appeared. There have been no
changes recently, and I have another form that uses the same format, but to a
different report. Can anyone tell me why this is happening and how to fix
it. Any help would be greatly appreciated. Below is the code on the command
button when the run time error appears.

Thanks

Private Sub cmdAccepted_Click()
DoCmd.OpenReport "New Rejections", acViewPreview, , "Prov = '" &
[Forms]![New Rejections]![lbReport] & "'"
End Sub

 

[Jeanette Cunningham]

What happens if you try this code. Will the report open?

Private Sub cmdAccepted_Click()
DoCmd.OpenReport "New Rejections", acViewPreview
End Sub


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[nadesico]

Hi,

If I use that code the report opens, but I want it to show only the "Prov"
chosen from the form

What happens if you try this code. Will the report open?

Private Sub cmdAccepted_Click()
DoCmd.OpenReport "New Rejections", acViewPreview
End Sub


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi,

I am using Access 2000, and have been using a form for the past year with
no
problems, then when I tried running the form today, I got a run time error
5
prompt, and I have no clue as to why this appeared. There have been no
changes recently, and I have another form that uses the same format, but
to a
different report. Can anyone tell me why this is happening and how to fix
it. Any help would be greatly appreciated. Below is the code on the
command
button when the run time error appears.

Thanks

Private Sub cmdAccepted_Click()
DoCmd.OpenReport "New Rejections", acViewPreview, , "Prov = '" &
[Forms]![New Rejections]![lbReport] & "'"
End Sub

.