A simple "notes" sub form

  • Thread starter Thread starter Simon Lang
  • Start date Start date
S

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