[AccessD] Iterating Controls

Hi Arthur,

You're looking too far to see it up close :)
On Error Resume Next

Mike Mattys
  ----- Original Message ----- 
  From: Arthur Fuller 
  To: AccessD 
  Sent: Sunday, March 09, 2003 10:03 AM
  Subject: [AccessD] Iterating Controls


  Here's a little snippet from some code I'm writing:

  <code>

      'Walk through forms

      For Each Frm In db.AllForms

          DoCmd.OpenForm Frm.name, acDesign

          a.WriteLine "Form: " & Frm.name

          'Walk through controls

          For Each ctl In Frm.Controls

              With ctl

  </code>



  The code errors on the second last line, complaining that "object doesn't support this property or method". What's the right way to reference the collection of controls on a form and then walk the collection? 

  I'm still hunting as I write this, so I may post my own reply.

  TIA,

  Arthur
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030309/17ffbf37/attachment-0001.html>