×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How To Drill Down Through Data

How To Drill Down Through Data

How To Drill Down Through Data

(OP)
I'm looking to do a 'drill-down' in an app.

I have seen a form which is a list of items, when you double click on a line - you can see more information on this item. For example, you search on a keyword, the app brings back a form with a msflex control(?) on it. If you double click on a line in this control you can bring back a form will all the information relevant to that record.

What is this controls name? Some code would be excellent!

RE: How To Drill Down Through Data


Sorry, no shortcut here -- there's no control that does this for you.

You have to write your own form that gets called when the user double-clicks. Typically, you pass to this new form the database key of the row they clicked on, and it uses it as part of a new query to go get the data it needs.

<user double-clicks>
Load DrillDownForm
DrillDownForm.TheKey = Recordset.Fields("TheKey")
DrillDownForm.Show vbModal

Chip H.

RE: How To Drill Down Through Data


Sorry, no shortcut here -- there's no control that does this for you.

You have to write your own form that gets called when the user double-clicks. Typically, you pass to this new form the database key of the row they clicked on, and it uses it as part of a new query to go get the data it needs.

<user double-clicks>
Load DrillDownForm
DrillDownForm.TheKey = Recordset.Fields("TheKey")
DrillDownForm.Show vbModal

Chip H.

RE: How To Drill Down Through Data

chip-

weren't sure if it posted correctly huh? (don't worry, sometimes it does that, sometimes it doesn't......nobody knows)

RE: How To Drill Down Through Data

Thanks chip - I'll have a go using that.

RE: How To Drill Down Through Data


robherc -
Anybody hear an echo in here?? <grin!>

yep, the browser hung up, so I hit the button again.


gms -
This situation is related to a question we always ask job applicants: How you do transfer data from one form to another? The answers we've gotten & points we assign range from:

I don't know = -1 point
I don't know, but I'll look it up = 1 point
Global Variable = 0 points
Public Variable in the form = 1 point
Public Property in the form = 2 points
Public Variable in the calling form = 0 points
Public Property in the calling form = 1 points
Function/Subroutine in the form = 3 points
Function/Subroutine in the calling form = 1 points

The reason that using the function/subroutine in the form gets the most points is it allows you to pass several values at once, saving the overhead of multiple calls to property functions. It makes for cleaner code, too.

If the function is in the calling form, it's also clean code, but it ties the callee form to the caller, making code re-use difficult, thus only getting 1 point.

Chip H.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close