Whta is the difference in the two db's

[Lou_Reed]

In the two db files that I have attached there is a sharp difference between them.



Open frmPersonnel on _10 version and then click the button open form to send email and all that you get is a white screen?

However, on _12 a slightly earlier version of the same program when you open frmPersonnel and then click the button to open the form to send email, it opens and shows the form as it is meant to be seen.

I am unsure as to why the first one fails to give the proper screen (giving a white screen) in form view, but shows the correct
form when I ask for design view. The latter form that fails db is only a few hours older than the db that does not fail on this open form to send email button.

Both are zipped and attached to this post.

I obviously cannot have a blank screen when opening this for to send email.

What is causing this failure.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

I think that I have found the solution to this problem, but I am still stuck on something that was mentioned several days ago. In the file of the attached db,
the varTO in frmEmail does not work. I believe that it is the term email address causing the fail. If I were to rewrite it as emailaddress then I would get the problem of
form frmEmail would not open up via the form frmPersonnel; in that case I would get a blank screen.

So, how do I fix this? The value email address is preferred for all the reasons above. However, it does not work well with the varTO line in the VBA code for frmEmail.

In that case varTO = null

I am just hoping that there is a work around.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[jwhite]

You are missing brackets in the following:

'-- Combo of name to send email to
stWhere = "[qryPersonnelMeeting].[email address] = " & "'" & StWho & "'"