Problem: I open a report and received an unwanted, “Enter Parameter Value” prompt.
The below query is the RecordSource for a nested subReport.
The WHERE clause is referencing a text box (txtBookingsID) on the subreport that contains the subreport in question.
The reference to the text box is apparently correct in some sense, because after I click "OK" on the unwanted "Enter Parameter Value" prompt that pops up, my report opens and the data is all correct and could only be correct if the text box is referenced and the values read by the query. I don’t enter a value in the pop up “Enter Parameter Value” prompt, I just click on OK.
Can you help me figure out how to get rid of the prompt?
SELECT Equipment.Equipment_Description, Booking_Equipment.Bookings_ID
FROM Booking_Equipment INNER JOIN Equipment ON Booking_Equipment.Equipment_ID = Equipment.Equipment_ID
Booking_Equipment.Bookings_ID = Reports!rpt_Booking_Sheet_All.Report!rpt_Booking_Sheet_All_SubRpt_Container.Report!rpt_Booking_Sheet_All_SupRpt.Report!txtBookingsID;