There are problems with the database you posted.
1. The Main Form that you are trying to open is based on this Query:
Code:
SELECT Reporting.DO_Role, Reporting.DO_ID, Reporting.Date, Reporting.Comments, DutyOfficers.Name FROM DutyOfficers INNER JOIN Reporting ON DutyOfficers.DO_ID=Reporting.DO_ID;
This query is pulling data from a Table called Reporting.
The table Reporting - has no data in it - so there will not be a match found when you click GoToChecklists on the DutyOfficerStart Form.
2. In the following code behind your Go to Checklists button - the code in red is mixed up. DO_Role - is not Combo8 on the Duty Officer Start form.
It is Combo15.
If you put the message box in like I did - you will get a DO_Role of 2 - which is a value for DO_ID.
Code:
Private Sub Go_To_Checklists_Click()
On Error GoTo Err_Go_To_Checklists_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "MainForm"
stLinkCriteria = "[DO_Role]=" & "'" & Me![Combo8] & "'"
MsgBox stLinkCriteria
'DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Go_To_Checklists_Click:
Exit Sub
Err_Go_To_Checklists_Click:
MsgBox Err.Description
Resume Exit_Go_To_Checklists_Click
End Sub
Can you tell me what you NEED to see when you click Go to Checklists?
Where is the Data that you need to see when your main Form opens?
Is the data in a Table?
3. Your Sub Form 'KitCheck subform' is based on a Table called KitCheck.
The table Kitcheck has no data in it.
Have you ever been able to run your Main Form and have it actually show you the data you need to see?
I'm not sure how you got to where you are but something looks like it got mixed up along the line.
It might be possible to simplify what you're trying to do if you let me know how you want to proceed.