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!