how can when i close the child form requery the parent form

[gstylianou]

Dear all,

I would like to have your help..

I have a main a parent form which named 'frmCustomers" and a child form which called "frmCustomerInvoice". In child form a have some calculated fields which are the same with some in parent form. I wanted, when the calculated field in child form updated 1) to close child form and 2) to requery the parent's related fields.

Moreover,

I wanted to work as i ask above but when any deletions persist on child form, the parent form to be requery and going to last record..

Please...helps..

Thanks in advanced

[twinnyfo]

gstylianou,

Are you talking about an actual "Parent-Child" set of forms--that is, the child form is embedded as a sub-form in the Parent Form? If this is the case, you can't close a child Form when it is open in a Parent Form. You simply can't do it.

However, if you are talking about another form that opens from a command button or some other event on one form, that is another.

If the latter is the case (which I think it is), then the simplest way is to add code in the "child" form in the On Close event which references the "Parent" form to requery. This is as simple as this:

Forms.FormName.Form.Requery

The second part of your question may be more complicated. What have you tried so far in your attempts to accomplish this? We can guide you through solutions if we have something to start with.

Hope this hepps!