Recent content by Tom55

When I run that msgbox I get the Work Email and Private Email addresses of the current candidate displayed. Works as it should, the Query just wont recognise it.

That's what has stumped me, the fact that the form is clearly open when asking for the references. I've checked and triple checked every name involved and all match perfectly. My email controls are in the Detail section of a form, inside a 'Rectangle' that is also inside a Tab. Does that make...

It is, it's not possible to access the Query without the form open, since the button that runs it is on that form.

Hi, thanks for the welcome. What do you mean by wrong place? Here is the SQL script in my Query; SELECT Email1.Subject, Email1.FromAddress FROM Email1 WHERE (((Email1.FromAddress)=[Forms]![Candidate]![WorkEmail] Or (Email1.FromAddress)=[Forms]![Candidate]![PrivateEmail]));

Hey all, Have a very annoying issue that has had me stumped for the last two days; whenever I use a reference to a control in another form as a criteria for my query, it wont recognise it. The form is always open as you cannot access the query without it. I am using...