Assign Tasks to a Table?

[Dasin]

Using Access 2003
We have a form that one team member fills out when a property is
listed. Different team members have different tasks to do on each
listing. What I would like to do is have a "button" that after the
listing is entered, have the user click the button and it automatically
assigns those tasks to each member, be it a way of having a form that
each member has a "tab" on and can click that tab and look at their
tasks for the day, or any other way to do this. I am open to all
suggestions. My thought was a Tabbed form that would have their name on
the Tab, and the information being populated on their part of the form.


Am I making any sense?

Any help really appreciated.

Thanks,

James

 

[Guest]

Hi James,

You probably want to have some sort of tasks table that records the relevant
task details against each property, with AssignedTo and CompletedDate fields
for each task.

Then, have a form where the users can select their name from a combo, and
the form will display tasks with no Completed Date assigned to the selected
user.

How does this grab ya?

Damian.

 

[Dasin]

Damian,

Sounds good, now I just need the mechanics of it. How would I do that
after inputting a listing. How can I take the info from the current
record and write it to a different table? I am not too literate in code
and I assume that is how it would be done.

Thanks,

James