How to make subform to use as log notes?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jmuirman - 31 Oct 2005 14:51 GMT

How do I make subform to use as log notes?

On my Contacts Form, I want to be able to store notes by date. I tried to
use the subform wizard, but whwn I populated the fields with data and saved
the record, the data wouldn't show up when going back to that record - yet it
did populate the table caled tContactNotes. I also got some message like "You
can't assign a value to this object". Anny Suggestions?

Thanks,

John

Reply to this Message

Bob Miller - 31 Oct 2005 21:23 GMT

You will need a record ID for the Contacts, preferably a Primary Key.
You will also need to link the subform to the form via the record ID.
This way, all notes will be associated with the contact they go with.
The record ID will be placed in the notes table when you enter any data
in the notes subform. You can then look up the specific date that you
enter in the notes table for every contact.
jmuirman Wrote:

> How do I make subform to use as log notes?
>
[quoted text clipped - 11 lines]
>
> John

Signature

Bob Miller

Reply to this Message