Discussion Locked

Adding a field by command button

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am using Access. I have a form that I need to have multiple additions to the field "notes". I want there to be a button that I can push and a new "notes" field pops up. Not every record will have additional notes, but most will have several. I need the "notes" field to be kept separate so when I run a report, they stay under the same project, but still separate.

2 replies

by maevinn

Create a table just for the notes. Have an ID field that can link of the ID field in the main table, and a memo field. Create a subform in the main entry form, and you can either configure it to be invisible until you hit the button, or have a sub form that you can direct to this form when you click a button. I prefer the latter--cleaner, and you can use it to bring in different forms as needed.

by maevinn

If you set it up as a sub-form, you can easily add a button for navigating to a new reocrd, the next record, etc.

This discussion is closed to new replies.