Arthur Fuller
fuller.artful at gmail.com
Thu Nov 12 10:13:09 CST 2009
Thanks. That explains it. Incidentally, this code is from a wizard-builder that I found on the net. It looks pretty nice. Years back there was a wizard builder for Access 2000 but it allowed only one wizard per app, which was a pretty serious limitation. This one gets around that problem nicely. Its heart is a class called clsWizard and an associated form you use to plant your subforms on each page. Then to execute a given wizard within your app, you call RunWizard wisName. The only thing is, you need to create all the subforms before building the wizard, which only makes sense. I forget where I got this wizard builder but I found it with Google, so it must be readily available. The guy who built it is on the Access development team. Anyway, thanks for clearing up the bang thing. On Thu, Nov 12, 2009 at 11:01 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > Arthur, > > > I've never seen a line of code that begins with an exclamation point > before. > > The ! is used because you are referencing a CONTROL on a form, not a > PROPERTY of an object. > > > With Forms(m_sFormName) > > referencing a FORM m_sFormName > > > !sfcWizPanel.SourceObject = ... > > referencing a CONTROL (scfWizPanel > > then a property of that CONTROL .SourceObject > > The correct syntax for Access is to reference controls with a ! and a > property with a . > > The compiler will try to fix any mistakes you make in doing this but you > really should use the > correct syntax. > >