Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error Message (WIN 2000 Acc 97)

    I have a bit of code behind a textbox on a subform to open a custom form with notes.
    When I double click I get the message: Object doesn't support this property or method
    I click OK, and the code fires.
    Here is the code behind the subform's textbox:

    Private Sub txtDATE_RCVD_DblClick(Cancel As Integer)
    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmnotes"
    stLinkCriteria = "[REC_id]=" & Me![REC_ID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    End Sub

    What would cause this error?

    As an aside, I do try to utilize the MSKB, but I guess there are some tricks I need to learn regarding how to
    search effectively.
    Select a Microsoft Product Access 97
    Search for object doesn't support this property
    Using The exact phrase entered
    NO RESULTS
    Using All of the words entered
    NO RESULTS
    Using Any of the words entered
    MSKB RESULTS
    Lots of articles - none that I can see relate to my issue


    How do you guys find answers at MSKB ? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Thanks for any help !

    Michael

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Error Message (WIN 2000 Acc 97)

    I don't see anything instrinsicly wrong with your code - in fact it looks much like the code created by the wizard when you want to open a form. So I suspect the error message is misleading, and what you may really have is a references problem. Do you get an error when you try to compile your code?
    Wendell

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Message (WIN 2000 Acc 97)

    It compiles fine.

    The issue was there is code behind the frmnotes On_Load event that was trying to reference a control
    on the subform incorrectly.
    Fixed that, fixed my problem.

    I love following up on former employees databases... <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    Thank you Wendell for your help. Even as vague as this was, you had it right !

    Thank you,
    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •