Another subforum requery question

[bodylojohn]

I have a form (form1) on wich resides a subform (subform1).

When I open a completely different form (form2) while the above mentioned forms are still open I add a record and then I close form2.

Subform1 is a continious form wich should requery so the added record shows.
I tried and tried and searched and searched but without results.

I read bob larsons manuel about subforms.
I also tried this:

Forms!frmITEM_SUBFORM_OVERZICHT!frmITEM_SUBFORM_OVERZICHT_RESULTAAT.Form.Requery

BTW... when I delete a record when i am on form2 it inmidiately disappearce from subform2.
What am i doing wrong?

 

[ShaneMan]

I have a form (form1) on wich resides a subform (subform1).

When I open a completely different form (form2) while the above mentioned forms are still open I add a record and then I close form2.

Subform1 is a continious form wich should requery so the added record shows.
I tried and tried and searched and searched but without results.

I read bob larsons manuel about subforms.
I also tried this:

Forms!frmITEM_SUBFORM_OVERZICHT!frmITEM_SUBFORM_OVERZICHT_RESULTAAT.Form.Requery

BTW... when I delete a record when i am on form2 it inmidiately disappearce from subform2.
What am i doing wrong?

Double check your form names and make sure they are correct. It should be:
Forms!ParentFormName!SubformName.Form.Requery

Next, the above should be in Form2 in an event that fires after data entry. Like the On Close event.

HTH,
Shane

 

[bodylojohn]

Double check your form names and make sure they are correct. It should be:
Forms!ParentFormName!SubformName.Form.Requery

Next, the above should be in Form2 in an event that fires after data entry. Like the On Close event.

HTH,
Shane

Thank you very very much.

I put the requery in the onclose event of form2 and it works.

 

[ShaneMan]

Thank you very very much.

I put the requery in the onclose event of form2 and it works.

Little late on this but your welcome and I was glad I could help.