How to make subform to use as log notes?

J

jmuirman

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
 
B

Bob Miller

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