requery shuts down form!

[Matthew Snook]

I have a nested form structure:
frm_Fish_ID contains:
frm_Pathology, which contains:
frm_PathMetricEdit.

The Pathology form is linked to the main Fish_ID form through linking fields. The PathMetricEdit form is linked, but the data source query allows only edits, not data entry (because of a required field in a connecting table). Because of this, I must open a popup data entry form to enter new data. Some sql code then appends this data into the appropriate tables. After new data has been entered (and the popup form disappears), the fields in the PathMetricEdit form still show no data! So I figured I needed to requery the subform. Is this correct?

I would like to requery the "PathMetricEdit" subform so that the newly entered data will be visible, but the following code

Forms![frm_Fish_ID]![frm_Pathology].Form![frm_PathMetricEdit].Requery

simply shuts down my main "Fish_ID" form without any warning or dialog. Simply goes away!

What am I doing wrong? Can I not use requery?

Thanks,

Matt

 

[Matthew Snook]

Duh.

DoCmd.Close

I found this little command further down in my code. I assumed that since it was in the popup form, it would close the popup form. Instead, it was closing my main form and leaving the popup intact! I have since found my own answer. Thanks for letting me sort through this in public...

Matt