ADO problem runtime error

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jeroen van vliet

    ADO problem runtime error

    Hello i made a form (register)with an ADOdatacontrol object named Userinfo
    (from lesson 22 on vbtutor.net/lesson22.html i made all the butoons and
    scripts etc, but when i load it and click on regsiter it gives me the
    following error message:

    runtime error'91':
    object variable or With block variable not set

    the in debug the line is highlighted

    in register

    Private Sub Form_Load()
    Userinfo.Record set.Addnew ////////////highlighted
    End sub

    what is wrng here??


  • Christopher

    #2
    Re: ADO 'Object variable not set' error

    X-No-archive: yes

    Jeroen,

    If you are getting an "Object variable or With block variable not set"
    error, it means the UserInfo object has not been declared or
    instantiated properly. You mentioned that you've placed all of the
    command buttons on the Registration form; did you also place the
    UserInfo ADO control on the form?

    Christopher.

    Comment

    Working...