Open Report to (always the same) ID

gaccess

Registered User.
Local time
Today, 18:26
Joined
Apr 17, 2011
Messages
32
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
 
DoCmd.OpenReport "rptIncident", acViewPreview, , "ID = 1001"
 
thankyou again
last week I ordered Access VBA for dumbos
nobody told me that the more you learned about this program the more you realise you don't know
 
So true; I still feel that way. Happy to help.
 

Users who are viewing this thread

Back
Top Bottom