[PooBear]

Greetings to all,
I am new to Access and very blue in the face. I trying to build a very simple case mgmt type database that will allow me to type comments/history on an existing record each time the record is accessed. I would like to include who posted the comments, date posted, and a follow up date. Thank you for any assistance.

Operating system - windows 7

[OBP]

PooBear, welcome to the Forum.
So how are you currently trying to do this?

[PooBear]

Thank you.
Access 2010 - I hope I understood the question.

I created a history table. Then I created a history form. Then I read in an Access book that I could create subform continously, but it just doesn't work for me or I am probably not comprehending correctly. Then I created a time table to track my time which I got it to compute, finally. I am piece milling each action and hopefully can put it all together on one.

[OBP]

If you want more than one comment per Case there are basically 2 ways to do it.
The normal way is to have a separate table for the comments with the Case key field Number and the comment, you create a subform based on the new table and add it to the Case main form.
The second method involves using a "Memo" field in the maintable and using VBA code to add data to it. This is a much more advanced technique.

[PooBear]

Thank you. I will continue to try the subform. Thanks again.