In my table I have a filed called "Project Team Members", it is possible to
have up to 5 team members, but not always. What I am envisioning is on the
form to have some form of a smart button that when clicked will bring up a
text box to add a name and each time the smart button is clicked another name
can be entered up to five names. Is this possible, Help?

Sure it is possible, but not a good way to do this.

You have a one-to-many relationship. You should have a second table that
stores the project number (or some other identifier) and the UserID of the
team member. If you have a project with one team member, it will have one
record in your table. If it has four team members, you will have four
records in your table.

In your form, you'd create a subform where the team members could be added
to a project. No need for buttons and pop-ups.


--
Rick B



"raj" <(E-Mail Removed)> wrote in message
news:13CE1863-41BA-4819-8627-(E-Mail Removed)...
> In my table I have a filed called "Project Team Members", it is possible
> to
> have up to 5 team members, but not always. What I am envisioning is on the
> form to have some form of a smart button that when clicked will bring up a
> text box to add a name and each time the smart button is clicked another
> name
> can be entered up to five names. Is this possible, Help?

Thank you Rick, this really helps.

"Rick B" wrote:

> Sure it is possible, but not a good way to do this.
>
> You have a one-to-many relationship. You should have a second table that
> stores the project number (or some other identifier) and the UserID of the
> team member. If you have a project with one team member, it will have one
> record in your table. If it has four team members, you will have four
> records in your table.
>
> In your form, you'd create a subform where the team members could be added
> to a project. No need for buttons and pop-ups.
>
>
> --
> Rick B
>
>
>
> "raj" <(E-Mail Removed)> wrote in message
> news:13CE1863-41BA-4819-8627-(E-Mail Removed)...
> > In my table I have a filed called "Project Team Members", it is possible
> > to
> > have up to 5 team members, but not always. What I am envisioning is on the
> > form to have some form of a smart button that when clicked will bring up a
> > text box to add a name and each time the smart button is clicked another
> > name
> > can be entered up to five names. Is this possible, Help?
>
>
>