Collect Data from Form

[mcarmody]

Hello All,



I am new to Access and stumbling my way through. I am using 2010 and would like to collect some information using the "Collect Data" feature. Here is what I need to do: I have a form that will contain information for patients. I will have some staff members enter basic demographic data in about half of the fields on the form for each patient. I then need the partially-completed form to be emailed out to the patient's physician to complete the data entry in the remaining fields. I have the physician emails in a separate table and can select the appropriate email address when using the "Collect Data" wizard. The problem arises when a physician name is attached to more than one patient. When this occurs, the physician receives and email containing the records for all of his or her patients. Does anyone know how to limit the list so that emailed form only contains one record?

Thank you,
Molly

[ranman256]

send the key. There should be 1 unique key for person/physician.
load all data using the key.