requery not working

[rry2k]

I have an app with a form and subform. The form displays records in datasheet view and when a button is clicked I bring up a different form to add a new record. The problem is: when the user clicks close and goes back to form1 the new record isn't there until I close the form and go back in. I've tried refresh and requery on various events but no luck.

Thanks for the help..Russ

 

[GB2]

Try this in the Close event

Application.Forms.Item("frmToRequery&quot.Requery

 

[Aivars]

Hi!
Forms("frmToRequery&quot.Requery
or
Forms!frmToRequery.Requery

If you want to requery subform then:
Forms("frmToRequery&quot("SubformName&quot.form.Requery
or
Forms!frmToRequery!SubformName.form.Requery

Aivars