I created an unbound text box that I named SelectedID. I want users to be able to type a specific ID that will pull up a form with the database information on an easier to read form. I entered this into the SQL
Not a lot actually. Is the RecordSource of the form "Cumulative Returned Receipt" based on the query "CumulID SelectedID Query"?
In such a case, you don't usually put a WHERE clause based on the contents of a control from a form in the query (mainly because the query fails if the form is closed). The query selects all records (i.e. no WHERE clause based on Requests.ID) and you open the second form (here "Cumulative Returned Receipt") with a criteria:
Docmd.OpenForm "Cumulative Returned Receipt", , , "Requests.ID=" & Me.SelectedID.Value