vba not working in Access 2003 Data Project

S

sbradley0

Hi all,

This is a weird one that I can't really explain except that I'm having
trouble getting some vba code to work in an Access Data Project.

The following sub works fine:

Private Sub btnDistributionAr_Click()
DoCmd.RunSQL "exec spCfxArDistribution"
txtDistLastRun.Value = Now()
End Sub

The following doesn't:

Private Sub lblHome_Click()
Me.varchild.visible = False '
End Sub

(and just in case, neither does this: Me!varchild.visible = False)

They both seem fairly straigtforward. My first thought was
references, but after obsessive googling I wasn't able to find much
that pointed me in the right direction.

Please help, and thanks in advance!
 
L

Linq Adams via AccessMonster.com

Is

lblHome

an independent label, or a label attached to a textbox? Independent labels
have a Click event, labels attached to textboxes don't.

What exactly is

varchild?

And lastly, are lblHome and varchild spelled correctly?
 
Top