this might seem silly
as a demo I only want a report opened to the same ID every time
currently I have been playing with and trying to find anything
(with record no 1001)
Private Sub btnDemo1_Click()
DoCmd.OpenReport "rptIncident", acViewPreview, , "ID = " & Me!ID
End Sub
of course this works and opens the report with whatever record Im on
how can I restrict it to ID 1001 ?
Im sure this is really simple just like me really
as a demo I only want a report opened to the same ID every time
currently I have been playing with and trying to find anything
(with record no 1001)
Private Sub btnDemo1_Click()
DoCmd.OpenReport "rptIncident", acViewPreview, , "ID = " & Me!ID
End Sub
of course this works and opens the report with whatever record Im on
how can I restrict it to ID 1001 ?
Im sure this is really simple just like me really