Continuation from 2 days ago

  • Thread starter Thread starter ALbert K
  • Start date Start date
A

ALbert K

Albert, what I ended up doing was create a subform for
frmStudents which when I select a row from listbox
Attendlist which shows all of the students classes, it
updates the subform with their information. If the class
showed that the student didn't attend then I select that
row. I also placed a button on this subform for the
MailSimpleMerge. I did not link (Master/Child)the 2 forms
since the main form query is for all the students and
listbox shows the students with the assigned classes.
Now when I press the button on the subform it still draws
in the information from the Parent form rather then the
subform. What do I need to do to change this so I can the
MailSimpleMerge to work? Is what I am trying to do
possible with your program?
 
Albert K I think I have it. Please provide feedback on
this.
What I did was create a form with the query from the
information I wanted. I created the button to merge and
an email button. On my students form I created a button
to link the 2 forms by the StudentClassID when they
select a row from the Attendlist. I click the button it
opens the No Show form with the students info. I select
the merge button. It performs its routine and saves the
form. I click on the email button it runs its macro with
the subject line, To field etc. All I have to do then is
attach the email. This I think will make them happy. Is
there an easier way or do you see any problems that may
come up?
 
Curt said:
Albert K I think I have it. Please provide feedback on
this.
What I did was create a form with the query from the
information I wanted. I created the button to merge and
an email button. On my students form I created a button
to link the 2 forms by the StudentClassID when they
select a row from the Attendlist. I click the button it
opens the No Show form with the students info. I select
the merge button. It performs its routine and saves the
form. I click on the email button it runs its macro with
the subject line, To field etc. All I have to do then is
attach the email. This I think will make them happy. Is
there an easier way or do you see any problems that may
come up?
Click to expand...

Sounds quite good to me!
 
Back
Top