Recent content by vonline

Thank you both for your replies. I actually found a solution to this problem. I found that I could add a requery command to the macro that forced the form to repopulate with data after the append query updated the table. So to sum it up for anyone coming to this thread for the same question...

Ok I am missing something then. Here's what I did to try that. I changed the data source of my form to be the staff table. Then in design view of the form I added a check box control to the detail portion of the form. Then when I view the form, either in datasheet view or form view, that...

True, but that still does not provide me a mechanism to make the list selectable for the purposes of generating the email. Unless I am missing something that is so obvious that you would assume I know about it. Please don't assume anything. I am comfortable getting into the guts of access, but...

What I am trying to do: I have a form launched from a switch board that allows users to send emails. I want to add a list of current staff members and their email address from which a user can select any number of people and then generate an email. I have no issues with the email generating...