Results 1 to 2 of 2
  1. #1
    Bigthinkor is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2011
    Posts
    2

    Angry help with combo box Restritions


    Hello everyone
    I hope everyone is having a wonderful weekend. I certainly enjoy having the time off to enjoy some of the things I love to do. One of my most current task.
    I have a combo box with a drop-down list of all my forms. Some of my forms have sub forms which are okay, but I do not want the sub forms showing up by themselves, how do I restrict certain forms from the list?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    wow, good question.

    how are you generating the list? through a systems table query or VBA collection?? it might help to know that.

    Subforms have the same ''type'' number in the systems table, because they are become "subforms" in the eyes of a human when they are embedded into other objects. They are always forms in the program's eye.

    I would assume the easiest way to do this would be to store a list of your forms that are serving as subforms somewhere in your app and exclude them from the sql that is providing the combo.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-24-2011, 07:11 PM
  2. Replies: 5
    Last Post: 01-02-2011, 10:09 AM
  3. Replies: 1
    Last Post: 08-26-2009, 10:45 AM
  4. Replies: 3
    Last Post: 02-26-2009, 10:17 AM
  5. Replies: 0
    Last Post: 08-17-2008, 12:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums