Form focus

[MartinF]

Hi,

I have a database that sends e-mails. When the E-mail message window closes, focus returns to the wrong form. There are two forms open at this point, a full screen non-modal/non-popup form and, open on top of if, a modal popup form.

It is the modal popup form that calls the E-mail and should recieve focus once the E-mail window closes, but what actually happens is that focus is returned to the form behind it, and when an attampt is made to set focus to the popup form, focus immeadiately switches back to the form nehind it.

Any ideas?

Thanks in advance

 

[LonnieJohnson]

After the send email command can you put a DoCmd.OpenForm command for the popup form?

Just a thought...

prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.

 

[MartinF]

Hi,

Thanks for the response, i tried that but it didnt work either, however, i played around a little further and managed to cure the problem:- if quickly make the form invisible and then visible again it will keep its focus.

 

[LonnieJohnson]

Nice move. I had to do that once. Whatever gets the job done. See ya... prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.