Microsoft KB Archive/105540

From BetaArchive Wiki
Knowledge Base

Article ID: 105540

Article Last Modified on 10/28/2003


  • Microsoft Visual Basic 3.0 Professional Edition
  • Microsoft Visual Basic 3.0 Professional Edition

This article was previously published under Q105540


Trying to reference the properties of a Recordset or Database using a data control that was passed as Control to a Sub or Function results in this error message:

Invalid object reference

In addition, passing a data control into a Sub procedure as Control may result in a general protection (GP) fault, as it does in this example:

   Sub subtest (crtname As Control)
      ' Simply having this line in the code causes the GP fault.
      ' If you turn the line into a comment, the GP fault does not occur.
   End Sub


Recordset and Database specific properties are not available to objects passed as Control. You should replace the "As Control" with "As Data." NOTE: the Data object type is not easy to find in the Visual Basic documentation. It is, however, listed with the other possible object data types in the "Object Variables" popup on the Help menu topic, "Database Objects." Object types include CheckBox, ComboBox, CommandButton, CommonDialog, Control, Data, DirListBox, DriveListBox, FileListBox, Form, Frame, Grid, HScrollBar, Image, Label, ListBox, MDIForm, OptionButton, PictureBox, TextBox, Timer, and VScrollBar. The Professional Edition adds the following additional object types: Database, Dynaset, Field, Fields, Index, Indexes, QueryDef, Snapshot, Table, TableDef, and TableDefs.


Pass the data control as Data. For example, use the following code instead of the code shown below in the MORE INFORMATION section:

   Sub MySub(d As Data)
      Debug.Print d.Recordset.EOF


The following code example gives the error message:

   Sub MySub(d As Control)
      Debug.Print d.Recordset.EOF    ' an error appears on this line
                             '^^^      with EOF highlighted

Additional query words: 3.00 gpf

Keywords: kbprb KB105540