Fields In Forms

[Paul Falla]

Dear Crispy

This can be done one of 2 ways. Both rely on a unique
identifier for the album. The easiest way is to have a
notes field in the same table as the rest of the info
pertaining to the album. Alternatively you can have a
separate table for the album notes, but you must have an
identifier which is the same unique value as the
identifier for the album itself. You can then add a
subform to your main form to show the album notes.

Hope that this helps

Paul

 

[Crispy]

They are notes that apply to the specific artist and therefore do not change
by atrist.

I tried the subform, which displays the correct data, but looks ugly, and
you cannot see all of the dtata when some of the notes are very long...

 

[Paul Falla]

If you don't have space on your main form to view all the
data in the subform, perhaps you could use the tab control
where the main information from your form could be shown
on the first page and then you have a second tabbed page
to display the Artist notes held in the Sub form, this way
you can size the sub form to be much larger

 

[Crispy]

Thanks - Neat idea - I will give it a try...

If you don't have space on your main form to view all the
data in the subform, perhaps you could use the tab control
where the main information from your form could be shown
on the first page and then you have a second tabbed page
to display the Artist notes held in the Sub form, this way
you can size the sub form to be much larger