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

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" wrote:

> 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
>
>

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

Damian S wrote:
> 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" wrote:
>
> > 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
> >
> >