i need a vb code to refresh my form after closing another form

Question

hello all

i have a form , contain a sub form in data sheet mode .... on the form header i have button , when you click this button it will open a form to enter data ,

so now what i want when i fill the information into the data entery form and after closing it

the subfrom ( which in datasheet mode ) to automatically show the new record ...

i hope you understand me what i need

Regards

Answer 1

In the second form's Form_Close event write:

Forms!myFirstFormName!mySubformControlName.Form.Requery

(of course you replace myObjectNames with yours)

---

-Tom. Microsoft Access MVP

Answer 2

thank you for the reply ...

what you mean by mysubformControl Name

Regards

Answer 3

The datasheet on your first form is a subform. When you dropped it on the form, Access created a subform control to host it. We nee the Name property of that control. This name is not necessesarily the same as the form it is hosting (which becomes the SourceObject property).

---

-Tom. Microsoft Access MVP