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

C

Crystal Carter

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

Klatuu

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

Crystal Carter

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

Klatuu

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