A
Arti
Guest
I don't know if this is possible, but I want to try to send a report by email by clicking a command button on a form. My problem is that the name of the report is determined by the value of another variable in the form. The form has a pull-down menu of names called "Assigned to:" and I want the button to send the report that has the same name as the value of "Assigned to:" to the person who's name is "Assigned to:". Is there a way to program a command button to have these variables and look them up from the form that the button is on?