Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How To Drill Down Through Data 1

Status
Not open for further replies.
gstenson

gstenson

Programmer
May 12, 1999
5
0
0
IE
I'm looking to do a 'drill-down' in an app.<br>
<br>
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.<br>
<br>
What is this controls name? Some code would be excellent!
 
Sort by date Sort by votes
<br>
Sorry, no shortcut here -- there's no control that does this for you. <br>
<br>
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.<br>
<br>
&lt;user double-clicks&gt;<br>
Load DrillDownForm<br>
DrillDownForm.TheKey = Recordset.Fields("TheKey")<br>
DrillDownForm.Show vbModal<br>
<br>
Chip H.<br>

 
Upvote 0 Downvote
<br>
Sorry, no shortcut here -- there's no control that does this for you. <br>
<br>
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.<br>
<br>
&lt;user double-clicks&gt;<br>
Load DrillDownForm<br>
DrillDownForm.TheKey = Recordset.Fields("TheKey")<br>
DrillDownForm.Show vbModal<br>
<br>
Chip H.<br>

 
Upvote 0 Downvote
chip-<br>
<br>
weren't sure if it posted correctly huh? (don't worry, sometimes it does that, sometimes it doesn't......nobody knows)
 
Upvote 0 Downvote
Thanks chip - I'll have a go using that.
 
Upvote 0 Downvote
<br>
robherc -<br>
Anybody hear an echo in here?? &lt;grin!&gt;<br>
<br>
yep, the browser hung up, so I hit the button again. <br>
<br>
<br>
gms -<br>
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:<br>
<br>
I don't know = -1 point<br>
I don't know, but I'll look it up = 1 point<br>
Global Variable = 0 points<br>
Public Variable in the form = 1 point<br>
Public Property in the form = 2 points<br>
Public Variable in the calling form = 0 points<br>
Public Property in the calling form = 1 points<br>
Function/Subroutine in the form = 3 points<br>
Function/Subroutine in the calling form = 1 points<br>
<br>
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.<br>
<br>
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.<br>
<br>
Chip H.<br>

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
API - multipart/form-data
Replies
3
Views
250
Swi
Swi
sal21
  • Locked
  • Question
how to read the coordinates in from this file
Replies
3
Views
191
Ken01
Ken01
Niki_S
  • Locked
  • Question
How to use a combo box to get data from SQL? 1
Replies
1
Views
83
Andrzejek
Andrzejek
2009luca
difficult to crteate a query very complicated 1
Replies
9
Views
824
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
187
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top