Adding & Tracking Comments

[JWhitehead]

I'm using MS Office 2007.

I've seen this done, but can't seem to get it to work. Any help would be greatly appreciated.

I've created a DB to track all details about equipment - maintenance, preventative maintenance, etc. All that is fine. The part I'm having some issue with, is I want to be able to click on "Add Comments", and have a window open where I can enter anything else in regarding that equip. Then on the main form, have it relate to it.

At this time, when I click on "add comments", it opens the window and I can add a new entry, only after clicking on the "Add New" option. I then have to select the user's name, equipment number, and enter the date of the note (all which is hidden).

What I would like it to do is when I click the button, it will open to a new comment, passing the user name, equip #, and system date/time to the new entry. If nothing is entered, do not save.

I know this isn't a good explaination without a visual, so I've attached the document. The login name is "user", and the password is "password" -- this is obviously just for the purpose of posting online.

I had found something online, and copied it over, but being that the field names are not the same, so I've updated it to my field names, it now doesn't seem to work as it should. I am sure it will be a simple fix, but I can't seem to find it.

Thank you for any and all assistance with this.

 

[Rockn]

You should probably create another table for comments and have a foreign key relating back to the main table.

 

[JWhitehead]

I have set up "Comments" as it's own table. See the attached DB layout.

 

[Rockn]

Just create a button and an event for that button to open a new form for entering comments where the equipment ID gets passed to the new form and will create a new record in your comments table.