Access 2000 Project
SQL2000 Backend
I have a Search Engine that opens a form(B) based on the selected record from the Search Results. Form B has a recordset based off of a SQL Statement with Input Parameters. Form B has 2 subforms one that is just informatory and is always Read Only (Edits, Additions, and Deletions set to No) the other subform is to add additional figures of which are summed and then added to the figures on the main From(B). The subforms, are for speed sake, not using the tradition subfrom/mainform links. They grab their recordset in the same way as the main form (SQL Statement with Input Parameters) As a matter of fact the subforms and the main form all have the same input Parameter.
The problem is as such. When opening the main form in Edit mode, both sub forms display their information and work normally. However when opening the Main form in Read Only Mode...the Informatory subform shows all of its data but the second subform for figures does not show its data. It does show its header and footer but it acts as there is a null set for a recordsource. and that messes up the the info dispayed on the main form as it pulls the summed figures from the now non displaying subform.
Why would the subform work while the Main form is in edit mode....but not while in Read Only mode?????
I have tried setting the allow Edits, Additions, Deletions properties(as this seems to be a main difference between the 2 subforms) upon opening in read only mode but that has no effect.
Any Suggestions????
SQL2000 Backend
I have a Search Engine that opens a form(B) based on the selected record from the Search Results. Form B has a recordset based off of a SQL Statement with Input Parameters. Form B has 2 subforms one that is just informatory and is always Read Only (Edits, Additions, and Deletions set to No) the other subform is to add additional figures of which are summed and then added to the figures on the main From(B). The subforms, are for speed sake, not using the tradition subfrom/mainform links. They grab their recordset in the same way as the main form (SQL Statement with Input Parameters) As a matter of fact the subforms and the main form all have the same input Parameter.
The problem is as such. When opening the main form in Edit mode, both sub forms display their information and work normally. However when opening the Main form in Read Only Mode...the Informatory subform shows all of its data but the second subform for figures does not show its data. It does show its header and footer but it acts as there is a null set for a recordsource. and that messes up the the info dispayed on the main form as it pulls the summed figures from the now non displaying subform.
Why would the subform work while the Main form is in edit mode....but not while in Read Only mode?????
I have tried setting the allow Edits, Additions, Deletions properties(as this seems to be a main difference between the 2 subforms) upon opening in read only mode but that has no effect.
Any Suggestions????