A simple "notes" sub form

[Simon Lang]

I have a contacts form and table which I'm pleased with. On that form I want
to place a simple subform that a user can add ad hoc notes against the
contact by date. How is this done so all the notes per contact show up and
that if there are many to have a scroll bar...thanks

 

[Klatuu]

If you want to have multiple notes per contact, you will need a ContactNotes
table.
It would need to include the Contact record's primary key, a date/time
stamp, and a memo field for the note.

You use the Link Master Fields and Link Child Fields properties of the
subfom control to have the notes for the selected contact presented.

You can turn on the Vertical Scroll Bar option in the form being used as a
subform.

 

[Simon Lang]

Thank you so much, works a treat, I've noticed though that now within the
main"form view" I can't scroll down the main form, i have to physically
pointer over the vertical scroll bar to drag it down

 

[Klatuu]

The scroll bar I suggested should be on the subform.