Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Subfrom Data not showing in Read Only mode

Author  Topic 

PETE314
Starting Member

37 Posts

Posted - 2005-02-16 : 11:49:10
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????

PETE314
Starting Member

37 Posts

Posted - 2005-02-17 : 07:27:06
Everyone else stumped too?????
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-02-17 : 09:08:07
This doesn't make sense .. is it possible for you to give us some simple steps to re-create this behavior? (i.e., using the Northwind database, create a form based on Customers with 2 subforms ... as so on ... very simple but just enough to reproduce what you are seeing.) Often this exercise is useful for you, as well, to ensure that it is indeed the behavior of Access and not some hidden setting or something odd on your existing form.

- Jeff
Go to Top of Page

PETE314
Starting Member

37 Posts

Posted - 2005-02-17 : 09:56:21
It doesn't make sense to me either....LOL And I tried to recreate without any real success.

So I did an exhuastive investigation on the data......I have JUST concluded that I have been given bad test data. There are holes in the data. Hence the null recordset, which just sets the entire dominoe chain into effect. In edit mode you can have a null recordset but you are given a field in which you can add a record and the default values(usually zero) give the other fields something to calculate. Not to mention you can see a record even if not filled completely....

So now I have to figure out how to get 0 to come up in my summations in read only mode when there is a null recordset.......my current summation field has a Control Source as such =Nz(Sum([curAdditionalPrice]),0) But it is not displaying zero in the Read only mode....It apparently doesn't know what to do with a null recordset.....
Go to Top of Page
   

- Advertisement -