Paul,
The data entry property was set to No as you advised.
I figured out a way to display the data. I have a jobOverview tab which displays each job in a list. When you select a job from the list it opens the financial report. I had my code as this then;
strFormNameJob = "frmJobOverview"
strFormName = "frmFinancialReport"
If IsOpen(strFormName) Then
DoCmd.Close acForm, strFormName
End If
Debug.Print varArgs
asWhere = "[JobID] = " & varArgs
MsgBox "For DEBUG purposes, WHERE is >" & asWhere & "<"
DoCmd.OpenForm strFormNameJob, acNormal, , asWhere, acFormReadOnly, acWindowNormal, varArgs
DoCmd.OpenForm strFormName, acNormal, , asWhere, acFormReadOnly, acWindowNormal, varArgs
DoCmd.Close acForm, strFormNameJob, acSaveNo
So it opened the overview, then opened the financial report and close the overview. The time process was a little delayed but it solved the problem for the time being. Do you think this is good practice? I am trying to learn as much of access as possible.
Michael