Have a report based on a query. This is how I am opeing the report from a buttonclick:
DoCmd.OpenReport "IndividualDonation", acViewNormal, , "[IndividualDonation].[ID]= " & Me.ID
I have a msgbox prior to this to check Me.ID and it is correct.
The report prompts for IndividualDonation.ID every time. If I provide it manually it opens with the correct result. Why is it not taking the profived where clause in the DoCmd?
DoCmd.OpenReport "IndividualDonation", acViewNormal, , "[IndividualDonation].[ID]= " & Me.ID
I have a msgbox prior to this to check Me.ID and it is correct.
The report prompts for IndividualDonation.ID every time. If I provide it manually it opens with the correct result. Why is it not taking the profived where clause in the DoCmd?