Adding an optional field or be able to add a field using a command

I am trying to find a way to be able to add a filed by using a command
button. I have a notes field and I would like to be able to puch a button on
the side of my form and then have another field of "notes" come up and be
able to do that any number of times.

If you need an unlimited number of notes associated with a record, you will
need to modify the design of your database and your form.
Database:
You will need a child table to the table you are working with. If all it
needs is a memo, then the table only needs a primary key of its own, a field
to carry the primary key of your main table (as a foreign key), and the memo
field.
Form:
Take the memo field off the form.
Add a subform based on the memos table. Use the subform to enter your notes.

"Crystal Carter" wrote:

I am trying to find a way to be able to add a filed by using a command
button. I have a notes field and I would like to be able to puch a button on
the side of my form and then have another field of "notes" come up and be
able to do that any number of times.

This isn't really working for me, I guess I need step by step instructions.
Is there a way I can use a command button to add this?

"Klatuu" wrote:

If you need an unlimited number of notes associated with a record, you will
need to modify the design of your database and your form.
Database:
You will need a child table to the table you are working with. If all it
needs is a memo, then the table only needs a primary key of its own, a field
to carry the primary key of your main table (as a foreign key), and the memo
field.
Form:
Take the memo field off the form.
Add a subform based on the memos table. Use the subform to enter your notes.

"Crystal Carter" wrote:

I am trying to find a way to be able to add a filed by using a command
button. I have a notes field and I would like to be able to puch a button on
the side of my form and then have another field of "notes" come up and be
able to do that any number of times.

There is no way to do all this with a command button.
You can't have an unlimited number of fields in a table. What I suggested
in my prior post is the correct way to handle this.

What is your skill level as an Access Developer?

"Crystal Carter" wrote:

This isn't really working for me, I guess I need step by step instructions.
Is there a way I can use a command button to add this?

"Klatuu" wrote:

If you need an unlimited number of notes associated with a record, you will
need to modify the design of your database and your form.
Database:
You will need a child table to the table you are working with. If all it
needs is a memo, then the table only needs a primary key of its own, a field
to carry the primary key of your main table (as a foreign key), and the memo
field.
Form:
Take the memo field off the form.
Add a subform based on the memos table. Use the subform to enter your notes.

"Crystal Carter" wrote:

I am trying to find a way to be able to add a filed by using a command
button. I have a notes field and I would like to be able to puch a button on
the side of my form and then have another field of "notes" come up and be
able to do that any number of times.