Delay form closing

[NextGen]

Is there any way to delay form closing?



My problem is the following: I have a form that I occasionally have to alter but that form needs to update a total row (worksheet view). Then I have this code to close that form and open another:

Private Sub Exit_Click()
On Error GoTo Err_Exit_Click        

Dim stDocName As String    
Dim stLinkCriteria As String

stDocName = "Clients"        
stLinkCriteria = "[ID]=" & Me![ID_Client]        
DoCmd.OpenForm stDocName, , , stLinkCriteria    

Exit_Exit_Click:    
Exit Sub

Err_Exit_Click:    
MsgBox Err.Description    
Resume Exit_Exit_Click

The issue is that I think that if I can delay the form closing , I can set something like

Me.ReportField_Total.SetFocus

to force the changes update..


Something like:

Something here to delay 5 seconds

Me.ReportField_Total.SetFocus 'To update the form in worksheet view...

DoCmd.OpenForm stDocName, , , stLinkCriteria

Hope this can may sense to you guys...

Thanks!

[Micron]

No, doesn't really make sense. When a form closes, any unsaved records are saved, assuming there's no record violations and a cancellation by the user. Your terminology is a bit confusing as well. A form doesn't have a "worksheet" anything.
Maybe say what you need to have happen in general terms rather than asking if it can be done a certain way. Such as,
"I need to open form2 from form1 and pass a value from form1.txtMyText to form2.txtAnotherText on form2, but I do/don't need to save form1 edits first".

Or we can assume I guessed and you need to do something like
If Me.Dirty Then Me.Dirty = False
then open form2 and pass a value using .OpenArgs of form opening method
then close form1

[June7]

This is a form in Datasheet view? What do you mean by 'update a total row'? Just want user to see the revised calc before form closes? Issues like this is why it's best to do aggregate calcs on reports instead of forms. If form is in Datasheet view, where is the button you click?

[pbaldy]

In addition, this statement isn't accurate:

Then I have this code to close that form and open another:

Your code opens another form, it does not close the first, and thus doesn't save the data. You'd want DoCmd.Close with the appropriate arguments.

FYI, I edited the first block of code. Sometimes the forum software goofs it up and puts things on the same line.