Results 1 to 7 of 7

Thread: Access (2000)

  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    Helsingborg, Switzerland
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access (2000)

    I am trying to search a PM field in a sub form but only get Not found as replay. The cursor is in the PM field in the form and even if the form shows the word I'm searching for Access replay Not found. Why???
    It works if I open the sub form as main form and search.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access (2000)

    Any time a form works standalone but not as a subform, it typically means that you are not properly addressing the subform. Subforms are NOT open forms, so you can't use the Forms!subformName!controlname syntax.

    How are you searching, and from where? that is, are you conducting the search from within the subform or from the mainform?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access (2000)

    Are you using code or the find dialog? If you're using the Find dialog, try setting the LookIn to the subform itself rather than a field, and set the Match to Any part of field.
    Charlotte

  4. #4
    New Lounger
    Join Date
    Jul 2001
    Location
    Helsingborg, Switzerland
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (2000)

    I'm using the find dialog for now, but will change to code if it works? In the dialog I use LookIn to the subform and Match to Any part of field.
    I works when I open the subform only, but not when I open the main form

  5. #5
    New Lounger
    Join Date
    Jul 2001
    Location
    Helsingborg, Switzerland
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (2000)

    Tried both from main form and subform, same result. The find dialog or wizard created code make no difference.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access (2000)

    Then I don't know why it doesn't work for you, because I use this technique in my subforms without problems. What service release of Access 2K are you running?
    Charlotte

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access (2000)

    Could you post the code you are using? I'm betting you are not properly addressing the subform.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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