Popup Form from a Subform

[MikeAngelastro]

Hi,

I have a form containing two fields that have buttons to bring up in popup forms the detail data behind each of them - ContactID and CompanyID. If I change the data within the ContactID popup form, the new data is reflected in the calling form's ContactID field. The same is true for the CompanyID field.

However, when I use this form as a subform on a tab control of a main form, the ContactID continues to work as before but the CompanyID does not.
That is, the new company is not visible until I click inside the CompanyID field on the main form. Why would these controls work differently when in a subform?

At any rate, I fixed the problem by using the following generic code on the close event of the Company popup form:

Forms![form]![subform].Form![CompanyID].Requery

This of course is prefaced with an if IsLoaded qualifier.

But although this fixed it, doesn't it remove the general usibility of the popup form? Is it the IsLoaded qualifier that makes it generally useful?

Thanks,

Mike