"search" within report?

[Gates Is Antichrist]

I'd like to put either a text box or 26 buttons on a report's page header, and jump to a later (or earlier) point in the report. Probably best would be some kind of Find in VBA. The thing is, I don't want to use Where or Filter because I'd like the opportunity to still page up to the "skipped" entries.

If there's no "Find," maybe grab BeforePrint or some event and issue some kind of scroll command (but that sounds flawed).

E.g., you click on the "E" button atop the report, and it goes to the first [detail] record beginning with E (detail happens to be the only grouping level in this app).

Furthermore, if this is not greedy enough ... can you then control where on the page the "target" record appears, or is that solely controlled by the Print Preview? Perhaps I could know that record 31 is the "target," and get record 27 at the top of the page? Again, not with filter or Where.

Another thought: could I skip around the Recordsource query via .GoToRecord to do this?

Y.A. musing: maybe I could run an invisible query that gives Count of left(Field1,1)<"E" and skip ahead/scroll report accordingly?

I'm just spewing what comes to mind. What would be the cleanest working approach?

 

[Norie]

Why do this on a report?

Why not create a form where criteria can be entered and set up the report do take those criteria as parameters?

 

[Gates Is Antichrist]

Probably because I'm a retard whose posts are mostly because I love the sound of my own voice.

Anyone else?

 

[Norie]

The reason I was asking why you wanted to do it on a report is because it's not something I've ever done or seen done.

The only way I've really used reports in the past is for printing a summary of data in a nice format.