Reading records....?

[zozew]

Hi All,

Im having a probably very basic problem......i have a form structure as below shows..

Form structure:

I have a Mainform, I also created a subForm and a subsubForm on the MainForm..... SubForm table is linked to MainForm table and SubSubForm table is linked to SubForm . The SubForm and SubSubForm on the MainForm are displayed as Spreadshets.

*My problem is that when i add a record on the MainForm but dont add values in the SubForm and/or add values to the SubSubForm, when i close and reopen the MainForm...it doesent read the records added to the MainForm table even if wheni check they are present in the MainFormtable...

Adding values to the SubForm or the SubSubForm makes the record visible in the MainForm if I cclose and reopen the MainForm...?

So as you see its probably some setting ive forgotten somewhere


thx

Z

 

[missinglinq]

What are the RecordSources for your main form, subform and subsubform?

 

[zozew]

I have one MainFormTable for the MainForm with about ten fields One of the fileds is linked to the SubForms SubFormTable and i have one field in the SubFormTable linked to the SubSubFormTable of the SubSubForm.

Basically its a Law person Database. In the MainFormTable i keep information about the person like specifics name height etc, in the SubFormTable i keep information about the persons "case's" case number, court branch, hearing date's..etc and that table is linked to the SubSubFormTable that keep information about the case's "hearing dates"

All these fileds are presented in the MainForm so you can enter it directly, like this...

Input a persons name and specificts....
Input case number, if ther are multiple cases, add more....
for each case add hearing date or multiple if there is...

save record....

all this is workinng but if you dont add any values to the SubForm (SubFormTable) when you close and reopen the MainForm...it doesent read that record in the MainFormTable even though it exists in the mainFormTable


When i open the mainFormTable i get a small plus sign in the first column where i can click and open and see the SubFormTable (cases) then in that table (still open in the MainFormTable) i get a plus in the first column that i can click on and open the SubSubFormTable and see all the hearing datees for that specific case...

So it seems that if you dont add values to the SubFormTable the MainForm Doesnt react to a neww created record that has been saved in thee MainFormTable.....

hope this explains it...

thx

Z