Problems with VBA when opening Report

[StefanScheidegger]

Dear colleagues

I am trying to open a report from a form with VBA. My current code is the following:

___________________________

Option Compare Database

Private Sub Befehl14_Click()

On Error GoTo Err_Befehl14_Click

Dim stDocName As String

stDocName = "Bericht"
DoCmd.OpenReport "Bericht", acPreview, , "[PeriodeID] = " & Me.PeriodeID

Exit_Befehl14_Click:
Exit Sub

Err_Befehl14_Click:
MsgBox Err.Description
Resume Exit_Befehl14_Click

End Sub

_______________________

Unfortunately, it is not working. the following error message comes up:

Microsoft Jet-Database-Module does not recognize '[PeriodeID] as valid field name.

Do you know what is wrong? [PeriodeID] is correct.

Kind regards,

Stefan

 

[mmtraining]

Hi, Stefan,

try moving the inverted commas:

DoCmd.OpenReport "Bericht", acPreview, , [PeriodeID] & "= " & Me.PeriodeID

or

DoCmd.OpenReport "Bericht", acPreview, , "[PeriodeID] = Me.PeriodeID"

The help file is not that helpful, but my gut feeling is that the inverted commas are in the wrong place.

All the best,

Carol, Berlin