Solved Passing ID from Form to Report

[JamieRhysEdwards]

Hi All,

I'm trying to open a Report in which it'll take the ID of the previous "Contact Details" form. This is what I currently have:

Private Sub CmdNewStarterReport_Click()
    DoCmd.OpenReport "ReportNewStarter", acViewPreview, , "ID='" & Me.ID & "'"
End Sub

However, when I tap the button, it still asks for the ID. I don't think I'm using this function properly. The "Contact Details" form is getting its data from a QueryContactsExtended query (which houses the ID of the subject)

 

[Eugene-LS]

However, when I tap the button, it still asks for the ID

Some thing wrong ...
Can you post a sample db with test data?

 

[JamieRhysEdwards]

I know something is wrong XD however, I'm not sure how I would even be able to make a sample db with this problem is as it's likely going to work...

 

[JamieRhysEdwards]

Yeah... Knew this would happen. The reason it was asking for the ID is because I hadn't set the Record Set on the Report itself.

 

[Eugene-LS]

Yeah... Knew this would happen. The reason it was asking for the ID is because I hadn't set the Record Set on the Report itself.

Very happy for you!
Good luck with your project

 

[Uncle Gizmo]

I note you have answered your own question, however, I thought this may be of interest:-

In this YouTube video I demonstrate how to pass a filter into a Report from a Form no code required in the Report:-

I have a blog on filtering which may be of interest:-

Easily Apply Filters - Nifty Access

Filtering - MS Access Forms This video should be of interest to anyone who wants to easily apply filters to an MS Access form in datasheet view or continuous form view. In this demonstration I show how you can apply filters in a Form presented in Continuous view and also in Datasheet view. When you

www.niftyaccess.com