vba not working in Access 2003 Data Project sbradley0 <sbradley0[ at ]gmail.com> 11/26/2008 8:44:44 PM 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!

Re: vba not working in Access 2003 Data Project "Linq Adams via AccessMonster.com" <u28780[ at ]uwe> 11/27/2008 12:48:44 AM 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? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com