Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    8

    Unanswered: conditional open a subform

    How can i open a subform at a condition and open a different one at another condition in the same main form.
    Thanks a lot.

    lxf

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    if something then
    SubFormGoesHere.SourceObject = "subForm1"
    else
    SubFormGoesHere.SourceObject = "subForm2"
    endif

    ...assuming you have a subform control in your mother form called "SubFormGoesHere" and you have saved forms "subForm1" and "subForm2"

    you might also want a "subForm0" with no controls (or maybe your copyright notice, or your logo, or a "Wake up and select something!" greeting to your users). subForm0 goes in at design time (or as .sourceobject on _Load).

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Nov 2002
    Posts
    8

    Thanks

    It works.
    Thank you very much.

    lxf

Posting Permissions

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