Form to update table

[Tcurtis]

I have a table with contacts in it and a table of task I would like to assign to people. How can I use one form to update the name and email fields of task table with the information from the contacts table? I have the form for the task/investigation but cannot figure out how to pull the contact information over to the form and have it update the task/investigation table. I would like to do this so I can send out an email with this assignment asking for updates using the data collection process built into access.

 

[ranman256]

in the form, youd have a list of contacts, and a combo of tasks.
select the task.
dbl-click each contact you want to add. On the dbl-click event, this runs an append query. the query appends the contact (from the list) and the task (in the combo) to the tAssignedTask table.
this result could also show in a list box on the form. (which must be updated each dbl-click, lstResults.requery)

Then once completed. You would have code scan thru the list, lstResults and send each an email.

 

[apr pillai]

1. Create a Combobox on the Task Form near the task table Name field.
2. Display the Property sheet of the Combobox.
3. Enter the following SQL String in the Row Source Property:

SELECT Contacts.Name FROM Contacts ORDER BY [Name];

4. Make changes in the SQL String to match table name and field name.
5. Change the Control Source property value to the Tasktable Name field.
6. Repeat Step-1 to 5 for the Email field too.

 

[Tcurtis]

Thanks, works great. Really helps me out.