on_exit

R

Rli

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?
 
J

jl5000

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
 
R

Rli

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
How to close form if code is still processing? 4
Closing a form through on exit field event 6
runtime error 3
Command button on got focus not working 5
err 2585 - this action can't be carried out while processing a form or report event 1
Runtime error 2585 0
requery then close form 4

Top