I use Access 2003, and have a form with a subform in it. I am trying to run a report based on a query. The query should only pull the information that is from the current record on the subform. However, every time I go to run the query I get a text box popping up asking me for the record I would like to pull. The query is not recognizing that the subform is open. I assume it only recognizes the form being open, because I have tried that and it has worked. Any suggestions. If there is anyway to just print the current record without using a query, I open to that as well.
Thanks in advance