Hi all
My problem is this, I am trying to get my report which works fine, to open at a user specified place in the total amount of records.
So in other words, when the user clicks the button to run the report on the Front End Form, they should be prompted with a box to enter some information, be it record number, or the unique reference each record has, and then they should be taken directly to that record, rather than having to manually seach for it.
Has anyone got a clue how best to do this?
Currently I simply have the button set up as an event procedure to preview the report, but it defaults to the first record in the DB, which when there is going to be 3000+ records added in the first year, will become cumbersome to say the least.
Any help will be greatly appreciated.
Thanks
Martin