Re: Active Visual Basic Module
From: Marshall Barton (marshbarton_at_wowway.com)
Date: 05/15/04
- Next message: Douglas J. Steele: "Re: Message for Duane Hookum re Concatenate"
- Previous message: Noel: "Re: Message for Duane Hookum re Concatenate"
- In reply to: LarBear: "Active Visual Basic Module"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 15 May 2004 12:17:43 -0500
LarBear wrote:
>I have a report that uses the same subreport multiple
>times on a page with different control names, ie: sub1,
>sub2, sub3. The subreport uses Visual Basic to populate
>the data in the subreport with a query. I need to find
>out if the Visual Basic code is currently running in sub1,
>sub2 or sub3 to provide different data.
Alex triggered an idea that you **might** be alble to take
advantage of if conditions are right. Your code in the
subform can check Parent.ActiveControl.Name to see which
subform control the active subform is contained in.
The problem with this is that, depending on where you want
to use that code, the main report may not be in a state that
has an active control. I.e. the subform's Open or Load
events. The Current event can be made to work if you skip
the first one or two times it's fired (before the mainform
completes its initialization).
-- Marsh MVP [MS Access]
- Next message: Douglas J. Steele: "Re: Message for Duane Hookum re Concatenate"
- Previous message: Noel: "Re: Message for Duane Hookum re Concatenate"
- In reply to: LarBear: "Active Visual Basic Module"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
