Collecting dat via email form Access 2007

[William Demuth]

I have a table called opportunities. I can update data and add data to the table by using the Collect info option in Access 2007.

All has been working well. My issue is, once an opportunity is closed (by a checkbox in the form) I no longer want to send it out for updates. I can not delete closed opportunities from the table, because management wants a history.

My problem is when I use a query to eliminate the closed opportunities, I can no longer send an Update email, only a new record email.

Can I filter records out of a table and still use the Collect Data via email option?

I have reviewed what I could find and see no reason it should not work, but it only offers me the new records option in the wizard.

Any clues would be great, because I am stumped.

 

[Melimolo]

I have the same problem. I have a table linked to another table for values. I created a query to link both values into one data set. When I click on "Collect Data" from the query, it only allows me to collect new records, not update existing ones.