Results 1 to 2 of 2
  1. #1
    Nokia N93 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    55

    choosing combobox option to open different form

    Hi
    if i want to make a combobox
    Type of calling : Personal, Question, Problem
    i put them in a combobox whith a button GO

    i want to open form 1 when i click Personal
    Form 2 when i click Question
    Form 3 when i click Problem

    how can i do that ??



  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    for example if I have a combo box say combo1:

    Dim strFormName as string
    if isnull(me.combo1) then
    msgbox "Please Select a value"
    Else
    Select case Me.combo1
    Case is = 1
    strFormName="Form1"
    Case is = 2
    strFormName="Form2"
    Case is =3
    strFormName="Form3"
    End SelectDoCmd.OpenForm strFormName
    end if

    Depending on the value selected in the combobox Form1 to Form3 will open
    put the code in the after update event of the combobox.

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

Similar Threads

  1. Replies: 29
    Last Post: 08-16-2011, 05:52 PM
  2. Replies: 0
    Last Post: 08-24-2010, 06:38 PM
  3. Union Query (choosing between two fields)
    By naveehgreen in forum Programming
    Replies: 1
    Last Post: 06-17-2010, 03:24 PM
  4. Replies: 0
    Last Post: 12-16-2009, 01:14 PM
  5. no option to import xls file or option all files
    By captgnvr in forum Import/Export Data
    Replies: 3
    Last Post: 09-22-2009, 10:19 AM

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