SubForm will not update after an insert

[kowalski]

Hi, I've seen many similar posts to this but nothing suggested seems to b working.

I have a form (frmSegments) with a sub form (sfrmSegments).
I update a field in the sfrmSegments and it triggers some code which does an insert (AddNew/Update) on the recordset.
I then want these new rows to display in the sub Form.
If I go to the next record (main form) and then back again, I see the new rows in the subform.
But the rows won't display otherwise.

I have tried combinations of the following to get the new row to display without success...



[Forms]![frmSegments].Requery
[Forms]![sfrmSegments].Requery


Me.Parent.Requery
Me.Parent.Repaint


Me.Requery
Me.Repaint

Cheers in advance!!

[RuralGuy]

Perhaps this link will shed some light on the subject: http://access.mvps.org/access/forms/frm0031.htm

[kowalski]

Perhaps this link will shed some light on the subject: http://access.mvps.org/access/forms/frm0031.htm

Thanks ...
So my code to add the new row and then requery is in the SubForm code. And I have tried this...

[Forms]![frmSegments].Requery
[Forms]![sfrmSegments].Requery

So I would think that it should requery the database and display the new row. But it's still not showing me the new row. Any ideas?

Cheers.

[RuralGuy]

If the code is in the SubForm then how about Me.Requery?

[Rainlover]

I update a field in the sfrmSegments and it triggers some code which does an insert (AddNew/Update) on the recordset.

Why do you do this.

The save will happen when the record loses focus. So there is no need to do this at all.

[kowalski]

If the code is in the SubForm then how about Me.Requery?

I have tried a Me.Requery but that does not display the new record.
Thanks.

[kowalski]

Why do you do this.

The save will happen when the record loses focus. So there is no need to do this at all.

The functionality is that I have a field called Number of Segments on the subform. This is defaulted to "1". in which case there is only a single record (in the subform). The user updates this to 2 or 3, ... And that many fields are created in the background via code. So the user enters 2, the code on the event for that control creates a second record, duplicating a bunch of information from the first record. That second record is created in the code using AddNew/Update.

Thanks.

[pradeep.sands]

copy-paste the following command in ur vba code...it should work...

SendKeys "+({f9})"

[RuralGuy]

I have tried a Me.Requery but that does not display the new record.
Thanks.

Then the new record has not been created yet!

[Rainlover]

Then the new record has not been created yet!

That being the case, we need to see the code that creates the new records.

What we are doing now is guessing.

[John_G]

Hi -

From what you describe, the main form has code to create new records you want to see in the subform. you have the right idea, that you need to requery the subform, but your syntax is incorrect. Try this:

me![subformcontrolname].form.Requery

Note that subformcontrolname is the name of the control on the main form that contains the subform; it is not the name of the subform itself.

HTH

John

[Rainlover]

That being the case, we need to see the code that creates the new records.

What we are doing now is guessing.

I just had a thought. After this insert and in the sane code segment run a command to open the Table just to see if the information has been added.

Don't forget to remove this when the problem is solved.