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.
| Author |
Topic |
|
PETE314
Starting Member
37 Posts |
 Posted - 2005-02-16 : 11:49:10
|
| Access 2000 ProjectSQL2000 BackendI 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????? |
 |
|
|
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 |
|
|
|
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..... |
|
|
|
|
|
|
|
|
Subfrom Data not showing in Read Only mode