Currently I am creating a Access Program that will search a list of records and then display the results of the search at the bottom of the screen in a sub form. What I want to be able to do is display the results of the subform into a report. But I cannot for the life of me figure out how to do it. Coding is not my forte so feel free to dumb it down for me. I was thinking I would need to create string and then do
str = ???
DoCmd OpenReport "Panel", acpreviewnormal, , str
For this example my main table is called panel
Contains fields such as MO, Qty, date, name, contractor, etc.
My subform is called panels it also contains the same information. So what do i need to make my str = ??? work? I am confused. Anyways thanks for the help. Bye.