In the attached db I am having trouble on the form frmEmail. That form has textboxes for MeetingID and MeetingDate. The boxes when I use them on form frmEmail seem frozen.
The record source for the form is qryPersonnelMeeting2 iis actually made up of two queries, with the first qryPerosnnelMeeting1 being part of qryPersonnelMeeting2. I had to do that the original query has ambiguous outer joins.
In a earlier version of this document - which was done incorrectly these boxes would move through the db (on the form frmEmail) when the arrows right or left (on frmEmail) was clicked.
The form that was the source was I think a Cartesian form (link?) which basically meant it listed all combinations so the meeting ysnMeetingID and MeetingDate would certainly
be there if one clicked on the form often enough. It was an error.
Now I have changed the source to qryPersonnelMeeting2. In which meeting ysnMeetingID's and MeetingDates should be returned. However, it is not working and I do not know why.
When I run qryPersonnelMeeting2 it shows all of the employees, but leaves the space blank for ysnMeetingID's and MeetingDates. That would explain why
I not getting them in frmEmail. But how to change, I do not know. I want to make this work.
The query is set up. I get no choices in frmEmail.
How do I fix this?
Respectfully,
Lou Reed