Results 1 to 2 of 2
  1. #1
    BwillieS is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    3

    When user selects form from a pull down menu the form opens up.

    Ok guys, I need a little help here.

    On my main form I've created a pull down menu that the user selects a form they want to display.

    I want it so they will select the form then press a "go" button and the main form will close and the form they selected will come up.

    I've made a table that has all the listed forms. I just don't know how to link the list with the forms.

    Thanks for any advice guys.



    Rob.

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Behind the GO button you would have code something like this:

    Code:
     
    Dim stFormName As String
     
    stFormName = me.NameOfComboBoxControl
    DoCmd.OpenForm stFormName
    DoCmd.Close acForm,"currentformname"
    You would use the table that has the form names as the row source for the combo box. The bound field would be that field that holds the form name.

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

Similar Threads

  1. Email form opens 2 emails
    By person1 in forum Forms
    Replies: 4
    Last Post: 12-13-2010, 06:19 PM
  2. Form opens for only seconds
    By MFS in forum Programming
    Replies: 5
    Last Post: 11-04-2010, 09:33 PM
  3. User selects pictures for report
    By NISMOJim in forum Reports
    Replies: 1
    Last Post: 10-29-2010, 03:06 AM
  4. Replies: 5
    Last Post: 08-11-2010, 09:16 AM
  5. Auto increment when the form opens
    By Lynn in forum Forms
    Replies: 13
    Last Post: 04-11-2010, 12:49 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