Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2011
    Posts
    21

    Unanswered: Query a table to a form using VBA

    I have a question. I have multiple groups of information that are labeled according to their group. when I use the docmd.openform "frmsoso" is there a way to query the table in the form according to a string I created in vba. Thanks!!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you can pass parameters and or filters as part of the openform arguments
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2011
    Posts
    21
    The problem I am having is, if you look in picture one. Here is my code. When i try it (look in picture 2) it wants a input parameter. I want it to bypass this step.

    Thanks!!
    Attached Thumbnails Attached Thumbnails 1.JPG   2.JPG  

  4. #4
    Join Date
    Oct 2011
    Posts
    21
    Ok I got it passed that point, but it is not filtering for that alone

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by Dargonian View Post
    Ok I got it passed that point, but it is not filtering for that alone
    Try da manuel
    OpenForm Action
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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