on_exit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have text-field on a form and want the form to close when certain
conditions are met and the user presses 'enter'

So i use the ON_EXIT event on the text field..
with some conditon tests
and put in
DoCmd.Close acForm, "formname"

access reacts with: run-time error 2585
'This action can't be carried out while processing a form or report event'

So how do i proceed? How to close down the current form anyway?

Can anyone help?
 
Try the AfterUpdate event of your text box to evalueate the conditions and
closing, you may need to save your record (docmd.RunCommand acCmdSaveRecord)
before closing
 
Thank you...right awnser...

jl5000 said:
Try the AfterUpdate event of your text box to evalueate the conditions and
closing, you may need to save your record (docmd.RunCommand acCmdSaveRecord)
before closing
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hoe to Close a NoData Report 1
Closing a form with VBA 8
How to close form if code is still processing? 4
runtime error 3
requery then close form 4
Required field on form 0
Closing Form with VBA Code 2
err 2585 - this action can't be carried out while processing a form or report event 1

Back
Top