By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Finding a Record then Previewing a Report

P: 3
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.


Jul 19 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
I think you've gotten the cart before the horse, Martin! You need to go to the desired record then open the report for Preview! To get started, take a look at this tutorial by ADezii on finding a specific record thru code. He actually gives three different methods for doing this:

If you have problems/questions get back to us.

Welcome to TheScripts!

Linq ;0)>
Jul 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.