In order to select and sort records for viewing on a form, I create a query then open my form using the query. Then from the form which happens to be landscape, I have a button for printing and the only way I've gotten it to work is to define the query a second time and open a report with the query and sending it to the printer. It seems so redundant. I'm thinking there must be a better way. So here are my questions.
1) Is there a way to sort the records if I open the form using the filters? It seems like a filtered form does not have an option for sorting the records.
2) Using an embedded macro for printing on the form always prints in portrait. From what I've read, I don't think there is a way to change the orientation of the form to use landscape. Has this changed?
3) Can I optimize my code by only using a report instead of a form? Since my form and report are almost identical, I was wondering if I could get rid of my form and just use the report..... but then I couldn't figure out a way to make it do the same thing, preview the report then print if the user presses a print button. If I put a print button on the report, is there a way to call the same report without having to re-define the query again?
I'm guessing I'm making this more complicated than I need to. Please help.