Results 1 to 2 of 2
  1. #1
    ttrautz is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    8

    Open a Specific Form with a Combobox

    I have a form (frmProjects) that has a combobox (cboJobStatus) that selects a status for each job in the system. The combobox selects from its own table (tblJobStatus) and has two fields - (JStatusID) is an AutoNumber PK and (Status) which has a listing of options (Close Out, Install, Design, etc).



    I would like to have it set up so that when someone chooses "Close Out" (corresponding PK is 8) - a form will pop up that the user needs to fill out in order to close the project out. However, the additional fields (if selected) should just act normally by inputting the project status.

    I am a newer user to Access - I used it about 10 years ago - and am now trying to get caught back up!

    Thank you for any advice you may have!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a table for the options in the combo
    Close Out, frmCloseOutForm
    Begin, frmBeginNew

    set the bound col = 2
    set the col widths 1;0 ...so the user only sees CLOSE OUT,
    click a button to 'open'

    docmd.openform cboStatus

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

Similar Threads

  1. Open Form To Specific Tab
    By shoelesscraig in forum Modules
    Replies: 4
    Last Post: 12-22-2015, 01:56 PM
  2. open specific form after login
    By manojsikar1 in forum Forms
    Replies: 1
    Last Post: 11-21-2012, 08:54 AM
  3. Replies: 1
    Last Post: 05-31-2012, 01:01 PM
  4. Open form on specific record
    By iky123 in forum Forms
    Replies: 1
    Last Post: 04-11-2012, 09:56 AM
  5. Open to specific form
    By ecpike in forum Forms
    Replies: 2
    Last Post: 06-12-2009, 08:32 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