subsubform record indicators problem

[MisterEkted]

Hi,

I have a form-subform-subform situation. The sub-subform has a command button to hide it when it is not needed. When I hide and then re-show it, the sub-subform record indicators (or navigation buttons as they are called) do not show that there are any records in the recordset. The records are in the table but thats it. If I create new records while the sub-subform is showing, the record indicators show them. Its only when I hide, then show again that they are gone.
Thank you in advance for your concideration.

Kerry

 

[dhookom]

You might need to add a line of code that requeries the sub-subform after displaying.

Duane
Hook'D on Access
MS Access MVP

 

[MisterEkted]

Well,

In the OnLoad event of the sub-subform I typed me.form.requery, and that did not do it. I don't think it is a requery problem but I am not sure. I noticed something else after my initial post...Even if the sub sub stays visible and I change records in either one of the parent forms, the record indicator resets as though there are no records in the recordset. I can tell this because there is an autonumber field and it is reset to (autonumber). In other words, the present record disappeared. Strange.

 

[dhookom]

Is the subform set to Add mode? I didn't expect you to add the Requery in the OnLoad event. I would put it in the code that made the subform visible.

Are the link master/child set up properly?

Duane
Hook'D on Access
MS Access MVP

 

[MisterEkted]

Dhookom,

thank you for that suggestion. I changed it and put it in the command button onclick event that makes the subform visible. No change. I will keep trying other things.

 

[MisterEkted]

Geesh. OK, I got it. Somehow the "data entry" property of the sub sub form was set to 'yes', and I should have had it set to 'no'. That seems backwards but I compared to to the main form and sub and they were set to 'no' so I changed it and it works.
Thank you very much for your efforts. This forum has been very helpful.