Tough One: Form to VBA
From: LarryP (LarryP_at_discussions.microsoft.com)
Date: 09/02/04
- Next message: Liz: "Re: Reset a form after saving record???"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Creating New Record from button"
- Next in thread: Bob: "Tough One: Form to VBA"
- Reply: Bob: "Tough One: Form to VBA"
- Reply: Dirk Goldgar: "Re: Tough One: Form to VBA"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 10:27:04 -0700
I have a form, not in worksheet view but a similar look -- continuous forms.
Along with a bunch of other stuff, the form contains four relevant values:
Workweek, Team, Subteam, and Data Item. The latter two values depend on
what row of the form is currently active, i.e., where the cursor is sitting.
Users have asked for a popup graph showing them how any particular Data Item
value looks compared to the previous 12 weeks.
I therefore need a way to capture the four key values to be used in
generating the graph. I thought about adding a "Graph It For Me" button, but
as soon as I click such a button I would lose the two row-related values.
No, I can't use the double-click; it's already in use for something else.
Anybody know how I can set the button so when I click it the first thing is
does is capture the Subteam and Data Item values from the row I was in before
I clicked the button? Or if not, does anybody have an alternate idea for how
I can get where I'm trying to go? Bottom line, I need an Event OTHER THAN
DOUBLE-CLICK that will grab all four values that I need to run a query and
eventually support a graph.
- Next message: Liz: "Re: Reset a form after saving record???"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Creating New Record from button"
- Next in thread: Bob: "Tough One: Form to VBA"
- Reply: Bob: "Tough One: Form to VBA"
- Reply: Dirk Goldgar: "Re: Tough One: Form to VBA"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
