Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004

    Unanswered: Opening a form in Access database

    I'm trying to have a different form open up based on a selection made in a field in a currently open form.
    Example: The user has frmOrders open. There is combo box on the form where the user can select, for example, Toys, Baseballs, Clothes, Cars or Shoes. If the user selects Clothes, then frmTextiles should automatically open up.

    What's the easiest way to make the above happen? Thanks in advance for any help offered.

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    Use Select Case in the OnChange event of the combobox.

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Or use a Select Case in the After Update event of the combo box

    If you do it in the OnChange, the code will run every time the user types a letter or backspaces... every time the content changes at all.

    If you do it After Update, the code will run once after the user finishes typing and presses TAB or ENTER, or as soon as the user clicks a specific item from the combo box.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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