Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Cool Unanswered: refer to a combo box on a subform?

    Hi all,

    I have a form called MAIN and it contains two subforms, SUB1 and SUB2 (SUB2 is a subform of SUB1)

    I have a combo box on SUB2 and I want to insert a command button that runs a query that is based on the combo in SUB2. Where do I put the command button (on the MAIN form? or on which subform?)


  2. #2
    Join Date
    Nov 2002
    San Francisco

    Re: refer to a combo box on a subform?

    you can stick your button anywhere in the main form....


    or anywhere in any form ....

    forms("myform").Form("sub1").form("sub2").form("co mbo0").value

    you can use the second method instead of the first (it will work just fine), but it is slower. If you call anything from current form use ME instead of name of the form.


Posting Permissions

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