Help

[giacomo1]

Ok-

Here we go.................

I have a form that has some fields that are used to display data only. The data is generated from a query that is executed based on a combobox selection. In order to have the fields that display the info appear empty when you click the add new record button I have the fields requery in the OnCurrent event.

My problem is this.....I have a close button that when pressed will close the form, however it will first ask the user if they want to save the record or discard it. The Problem: After the user clicks no the form begins to close, however, the On current event attempts to requery those boxes and Query Parameter boxes pop up looking for values....How can I work around this?????


Help!

Thanks

Giacomo

 

[dynamictiger]

You could consider trigerring a close of the subform from the main form, and in the subform test for a value on the main form. So something like:

SubformCurrent

IF Not mainform.chkClose then

Do something

End if

In which case nothing will happen.

Then toggle the value of chkClose in the mainform.