I was able to get most of this setup as intended. My record source on the Main Form is pulling from tblProjects, where PROJECT_ID is equal to [Forms]![frmProject_Management_Main].[lstProjects]
[lstProjects] is the List Box control - now unbound. When you click on the Project from this list, it loads the related Task Info from tblProject_Tasks in a sub-form (linking PROJECT_ID from the main form to PT_PROJECT_ID in the sub-form).
I still can't for the life of me figure out how to ADD a new Project via the Main Form.. so I added a button which opens up a separate form (frmNew_Project).
The user enters the Project Name and Description in this form, then clicks "Submit" button. The Submit Button has the following code which inserts that new project into the table. I'm sure there's a better/smarter way to do this though.
Code:
Private Sub btnAddProj_Click()
Dim strProjName As String
Dim strProjDesc As String
Dim strSQL As String
Me.txtProjName.SetFocus: strProjName = Me.txtProjName.Value 'Project Name
Me.txtProjDesc.SetFocus: strProjDesc = Me.txtProjDesc.Value 'Project Description
strSQL = "INSERT INTO tblProjects (PROJECT_NAME, PROJECT_DESC)" & _
"VALUES ('" & strProjName & "', '" & strProjDesc & "')"
DoCmd.RunSQL strSQL
DoCmd.Close acForm, "frmNew_Project", acSaveNo
Forms![frmProject_Management_Main]![lstProjects].Requery
MsgBox "Project Has Been Added"