Slider events in subform don't fire.

K

Kipp Woodard

When I use a form that has a Slider control on it as a subform, the
Slider_Change event never fires. I works fine when the form is not a subform.

Any work-arounds?
 
T

Tom van Stiphout

On Wed, 16 Sep 2009 06:00:01 -0700, Kipp Woodard

That's not the behavior I am seeing. As a test, drop that slider form
on a new form thus creating a subform, and see if it works. It did for
me.

-Tom.
Microsoft Access MVP
 
K

Kipp Woodard

Thanks.

I experiemented with a new/test form/subform, and it worked fine.

I then removed the subform control from my form. After saving and closing,
and then re-adding the subform, the slider events worked as expected.
 
T

Tany Van aerde

Hi,

If I do not insert the MsgBox, then the chart returns blank. If I run
step-by-step (even without MsgBox), then everything works fine (like before
my upgrade to Vista/Office 2007)

Sub Spin_Click()
MsgBox Me.Spin.Value
ChartIt (Me.lboTickers.Value)
Me.lboTickers.SetFocus
End Sub

Looks like the Slider (named Spin) value does not "saves" the value before
the command ChartIt is in exec.

I noticed as well, that the event properties show:
- Enter
- Updated
though I work with Click.
As Reference I have activated: MicroSoft ActiveX Data Objects 6.0 Library.

Any suggestion ?

Thanks.

T
 
D

Douglas J. Steele

See whether putting DoEvents makes a difference.

And I'd recommend removing the parentheses in your call to ChartIt.

When invoking a sub, you should use either

Subname parm1

or

Call Subname(parm1)

Subname(parm1) is subtly different: you're passing the argument ByVal,
rather than the default ByRef.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top